﻿using System;

namespace ConsoleApp1
{
    class Program
    {
        static void Main(string[] args)
        {
            string str = "-- MySQL dump 10.13  Distrib 8.0.20, for Win64 (x86_64)---- Host: localhost    Database: mdpmdb-- -------------------------------------------------------- Server version	8.0.20/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!50503 SET NAMES utf8mb4 */;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;---- Table structure for table `approles`--DROP TABLE IF EXISTS `approles`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `approles` (  `Id` char(36) NOT NULL,  `TenantId` char(36) DEFAULT NULL,  `RoleName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `PermissionsDescription` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `ParentId` char(36) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `IX_AppRoles_ParentId` (`ParentId`),  KEY `IX_AppRoles_TenantId` (`TenantId`),  CONSTRAINT `FK_AppRoles_AppRoles_ParentId` FOREIGN KEY (`ParentId`) REFERENCES `approles` (`Id`) ON DELETE RESTRICT,  CONSTRAINT `FK_AppRoles_Tenants_TenantId` FOREIGN KEY (`TenantId`) REFERENCES `tenants` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `approles`--LOCK TABLES `approles` WRITE;/*!40000 ALTER TABLE `approles` DISABLE KEYS */;INSERT INTO `approles` VALUES ('08d9c356-5645-42a8-8feb-ef07d8905a38','2de1cd24-b4ad-41b3-937b-62088b818ebe','超级用户','可以管理上和医院的的一切事物',NULL),('08d9c356-5647-41be-869f-1bdda208695c','2de1cd24-b4ad-41b3-937b-62088b818ebe','院长','比超级用户小一点',NULL),('08d9c356-5647-4219-84d9-657fac52d471','2de1cd24-b4ad-41b3-937b-62088b818ebe','部长职位','管理部的','08d9c356-5647-41be-869f-1bdda208695c'),('08d9c356-5647-4247-8653-404cfff08fc0','2de1cd24-b4ad-41b3-937b-62088b818ebe','科长职位','管理科的','08d9c356-5647-4219-84d9-657fac52d471'),('08d9c356-5647-427f-8e52-196aefb750e5','2de1cd24-b4ad-41b3-937b-62088b818ebe','普通员工','普通员工','08d9c356-5647-4247-8653-404cfff08fc0');/*!40000 ALTER TABLE `approles` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `appusers`--DROP TABLE IF EXISTS `appusers`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `appusers` (  `Id` char(36) NOT NULL,  `PassWord` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `UserName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `Account` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `AccountStatus` tinyint(1) NOT NULL,  PRIMARY KEY (`Id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `appusers`--LOCK TABLES `appusers` WRITE;/*!40000 ALTER TABLE `appusers` DISABLE KEYS */;INSERT INTO `appusers` VALUES ('029e5ad6-35ab-4217-8ed2-b9c5a6fd1950','555','吴六','17687161519_WULIU',1),('038941b6-1611-4e08-b59a-36def6456b2a','555','韦三','17687161519_WEISAN',1),('0939f0e7-17fa-44da-b6d1-d73a91bfe168','555','李八','17687161519_LIBA',1),('1014e47b-21bd-4f1f-9a71-c46330f8fa37','555','刘三','17687161519_LIUSAN',1),('10de1baa-4c0f-4cf2-90c7-81531fbcbe51','555','钱五','17687161519_QIANWU',1),('14611de8-e7a2-40d1-9a2e-d33b82c180f0','555','郑九','17687161519_ZHENGJIU',1),('15edbd6e-187c-4c04-a380-d83825ef899f','555','赵 四','17687161519_ZHAO SI',1),('1925e1e1-b563-4680-9965-8815d0ba4c45','555','吴九','17687161519_WUJIU',1),('1a483b1a-6a13-4bcb-a620-d1e009d346f5','555','赵 十','17687161519_ZHAO SHI',1),('1c4c8270-9c22-422b-b0b8-81c221a262e8','555','王三','17687161519_WANGSAN',1),('1d512be0-8677-43af-92e7-e1a5293695ac','555','李园长','17687161519liyuanzhang',1),('1fb6ae28-e984-46ad-a7f1-7b255e9486f5','555','李七','17687161519_LIQI',1),('20619ea5-cd00-41cd-ac4a-829d26464c29','555','吴八','17687161519_WUBA',1),('238ef535-4638-423f-a188-adf2d8799691','555','吴五','17687161519_WUWU',1),('28b2a05c-e37d-45a2-a478-73b2689d62f5','555','郑十','17687161519_ZHENGSHI',1),('2cff04b8-7a56-449c-adf3-3a37e6fe0487','555','赵 一 ','17687161519_ZHAO YI ',1),('34247837-31a8-4aab-983e-945c4986b46c','555','孙二','17687161519_SUNER',1),('350254a5-4ef4-4142-851a-23ada94739a6','555','孙七','17687161519_SUNQI',1),('3562c899-6e38-4289-961f-906035fe5548','555','刘八','17687161519_LIUBA',1),('3599e786-959d-4b7a-82e9-9c67d7906e41','555','李六','17687161519_LILIU',1),('36348229-87bd-4248-8237-e348b49392c2','555','张霄','17687161519_zhangxiao',1),('3b156e11-8fa2-46e1-aeda-53bab972451e','555','李九','17687161519_LIJIU',1),('3ba655b5-fca4-453a-b9c7-5356fd1b59fc','555','郑四','17687161519_ZHENGSI',1),('41328048-135c-46b5-a30b-74d00fccfe4d','555','钱二','17687161519_QIANER',1),('415a8695-7515-45e4-9b78-a0b13d28e5df','555','孙六','17687161519_SUNLIU',1),('45afcb5c-b041-4905-9bea-a447d050b1df','555','周一 ','17687161519_ZHOUYI ',1),('4c745261-9139-4fc5-963e-6f6a37db7682','555','韦五','17687161519_WEIWU',1),('4cdf55d8-6388-4c67-9a3f-96f738e408a2','555','刘二','17687161519_LIUER',1),('4d23f636-1198-4653-b225-749024c89c15','555','郑六','17687161519_ZHENGLIU',1),('4d5ce3bf-d192-41ce-a3e4-a59a07a5961d','555','孙十','17687161519_SUNSHI',1),('504ad0a2-6971-4126-891e-245ff090c5d8','555','555','555',1),('51ecccf2-09c6-497c-be5d-608740747dd3','555','吴三','17687161519_WUSAN',1),('528d092d-a0ac-488b-9522-c711ec567caf','555','李三','17687161519_LISAN',1),('52fb6512-8fd9-4f6e-9834-dcd3c142735c','555','韦一 ','17687161519_WEIYI ',1),('5820ad78-7074-4e7b-bb22-8d95a82993ef','555','刘五','17687161519_LIUWU',1),('5def466f-c513-446f-a82e-23ce3128299d','555','钱三','17687161519_QIANSAN',1),('5f7ee161-bde9-4247-85ce-ddd3e16a8da2','555','赵 六','17687161519_ZHAO LIU',1),('62e30894-258a-4724-b584-468d8de32804','555','吴十','17687161519_WUSHI',1),('63edec0a-49eb-4883-be74-1dffdb388c15','555','李一 ','17687161519_LIYI ',1),('66d47d99-5ea2-414d-9ecd-0d089456f3ca','555','韦十','17687161519_WEISHI',1),('68ef38f0-eb06-4701-92f2-3d30bdf00498','555','赵 七','17687161519_ZHAO QI',1),('6987b297-5130-44bb-b2c0-1320b3390c93','555','刘十','17687161519_LIUSHI',1),('6aad186b-1e82-4fe3-97ab-0aaca9c8b9fc','555','郑五','17687161519_ZHENGWU',1),('6ad42e18-7e75-41d9-bdea-d89c7dc76e7a','555','郑八','17687161519_ZHENGBA',1),('6ea4ba21-dc6c-4c2d-aab8-9cd76eead618','555','钱六','17687161519_QIANLIU',1),('717b7d03-9b43-456c-be24-3ca7c9f5e53e','555','孙五','17687161519_SUNWU',1),('7302f713-8f48-4966-a602-a9684edfe818','555','周五','17687161519_ZHOUWU',1),('734b2208-1830-46b4-94b4-53133f171354','555','周三','17687161519_ZHOUSAN',1),('770e016c-7354-4438-b781-8494bc56797b','555','王七','17687161519_WANGQI',1),('78d87239-c127-431a-b41c-c9314d8ce707','555','周七','17687161519_ZHOUQI',1),('7908fca3-22cc-40e9-8dca-7221c2acd627','555','孙四','17687161519_SUNSI',1),('796ba9db-ed1e-470e-9544-c16302fb9446','555','郑七','17687161519_ZHENGQI',1),('7a948bdd-3930-444c-a608-0600286b2e88','555','孙九','17687161519_SUNJIU',1),('7b15c899-4f69-4177-ab43-cceb104e4261','555','钱九','17687161519_QIANJIU',1),('7befc9bb-9ba2-419a-a2be-57119ff1a541','555','王六','17687161519_WANGLIU',1),('7f9b7e1f-cd1f-4f89-af58-c7d73db60f44','555','赵 八','17687161519_ZHAO BA',1),('83adb48c-fb81-4f1f-9220-e0949835aff7','555','孙三','17687161519_SUNSAN',1),('83dbe7a5-d9e0-48d6-a66e-4b6f65831364','555','钱十','17687161519_QIANSHI',1),('874126c7-654b-4928-91c1-a5c041b0edfe','555','韦八','17687161519_WEIBA',1),('875a23bd-3d61-49f0-9cd3-03a5655f9f1d','555','赵 三','17687161519_ZHAO SAN',1),('87c40ea2-1d51-4764-9aef-15c29c99cf78','555','王二','17687161519_WANGER',1),('87e7afc0-de73-47f6-b24b-997a1b420e49','555','周二','17687161519_ZHOUER',1),('91b015bf-fca3-48e2-ae11-97a514a3da37','555','周六','17687161519_ZHOULIU',1),('94bed3b2-5325-4122-835b-5ca72309dee6','555','刘四','17687161519_LIUSI',1),('9a03c468-c46c-49e3-beab-cdcf46e0f0ab','555','赵 二','17687161519_ZHAO ER',1),('a3e86d2c-c17b-4b18-8a33-780d47de11b3','555','钱一 ','17687161519_QIANYI ',1),('a4170123-71e8-4bfa-91ee-5a5c3c16e543','555','李十','17687161519_LISHI',1),('a5dbc9f1-1ea9-4a16-a369-a7051ba4766e','555','韦二','17687161519_WEIER',1),('a6056daf-e741-4c51-a41a-58fd27682001','555','李四','17687161519_LISI',1),('a7a37837-1f79-4b3a-abda-485dbf033b1c','555','钱八','17687161519_QIANBA',1),('a9cac001-76cb-4c7f-93ec-7679afc3d293','555','刘九','17687161519_LIUJIU',1),('aadb1695-5daf-4a71-a32b-1727fb92040b','555','吴七','17687161519_WUQI',1),('b2b0bb3d-8cad-4abf-8c77-816d1c64099c','555','钱四','17687161519_QIANSI',1),('b4563d9e-65d2-45f5-ba8d-65b9a40f5fe5','555','王四','17687161519_WANGSI',1),('b52804ad-e724-44af-8ee9-980c1cf013ce','555','吴二','17687161519_WUER',1),('b58a7116-0680-4ccd-be35-3987834b4bb0','555','郑三','17687161519_ZHENGSAN',1),('b62b7209-a822-487d-a368-c285971b4ede','555','韦七','17687161519_WEIQI',1),('ba5ad2e6-0859-4a47-902f-22aabf8c269b','555','王一 ','17687161519_WANGYI ',1),('babc954a-941f-4e4e-979c-6452fee0ebe8','555','韦九','17687161519_WEIJIU',1),('bceaa683-9a97-4cde-9e92-56c8ad4ab743','555','周四','17687161519_ZHOUSI',1),('bd8bdc65-6453-484e-985a-a3ec207d02b8','555','赵 九','17687161519_ZHAO JIU',1),('c350693f-dbe0-4ee0-9b16-3df0ed6de9ac','555','韦四','17687161519_WEISI',1),('c53073ad-003d-414a-be37-d9b04aad8368','555','周十','17687161519_ZHOUSHI',1),('c57e7135-059f-40b5-be69-0483e26b90ae','555','王五','17687161519_WANGWU',1),('c5abd27f-3d5b-4b5f-baeb-f405656d11c3','555','赵 五','17687161519_ZHAO WU',1),('c770b6a2-0679-4994-b907-c033df921a76','555','郑二','17687161519_ZHENGER',1),('cbc6f341-3d90-4aff-a987-397f2da5e25b','555','周八','17687161519_ZHOUBA',1),('d2ac4c81-7ced-4c1b-bc28-00fa4c1c03a3','555','孙一 ','17687161519_SUNYI ',1),('d3a6862c-f791-4130-badd-2119c728ca50','555','李二','17687161519_LIER',1),('d6ae8b5a-e7ca-4399-b02e-4ee882237ba2','555','郑一 ','17687161519_ZHENGYI ',1),('d6b4357d-fe12-488b-a6b0-b387db8beba6','555','王八','17687161519_WANGBA',1),('d83d44b7-2e7b-4874-b3c9-6f9e189405cc','555','刘六','17687161519_LIULIU',1),('dc6d61b0-e074-41a0-8689-4110a202b7cc','555','钱七','17687161519_QIANQI',1),('e0763d83-a8ec-4838-98d9-6eea74b9bf26','555','周九','17687161519_ZHOUJIU',1),('e2d30931-43f4-4088-aa9b-4ce8098b05eb','555','吴一 ','17687161519_WUYI ',1),('e40e65b3-8a78-4ebe-8566-8d62f57eae30','555','韦六','17687161519_WEILIU',1),('e735e75f-5521-48f2-acea-7a9350e87b94','555','孙八','17687161519_SUNBA',1),('e97fd6c1-dde1-41fb-acc2-dcf84cc96db0','555','刘七','17687161519_LIUQI',1),('eaf7a6a9-c495-4582-bd6b-7e7ab022e9e2','555','王九','17687161519_WANGJIU',1),('f480f547-7112-4488-83ea-6ecc2fa611dc','555','吴四','17687161519_WUSI',1),('f6800e6e-e5c2-4f3d-9215-404912b8b734','555','李五','17687161519_LIWU',1),('fc87ebde-821a-4938-b715-39511329595b','555','刘一 ','17687161519_LIUYI ',1),('fc9d6b75-cf91-486d-9aa8-03a0993b39ec','555','王十','17687161519_WANGSHI',1);/*!40000 ALTER TABLE `appusers` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `appusewithapproles`--DROP TABLE IF EXISTS `appusewithapproles`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `appusewithapproles` (  `Id` char(36) NOT NULL,  `AppUserId` char(36) DEFAULT NULL,  `AppRoleId` char(36) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `IX_AppUseWithAppRoles_AppRoleId` (`AppRoleId`),  KEY `IX_AppUseWithAppRoles_AppUserId` (`AppUserId`),  CONSTRAINT `FK_AppUseWithAppRoles_AppRoles_AppRoleId` FOREIGN KEY (`AppRoleId`) REFERENCES `approles` (`Id`) ON DELETE RESTRICT,  CONSTRAINT `FK_AppUseWithAppRoles_AppUsers_AppUserId` FOREIGN KEY (`AppUserId`) REFERENCES `appusers` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `appusewithapproles`--LOCK TABLES `appusewithapproles` WRITE;/*!40000 ALTER TABLE `appusewithapproles` DISABLE KEYS */;INSERT INTO `appusewithapproles` VALUES ('01dbc372-2bd8-4a7d-85ab-bc9932a8586d','7908fca3-22cc-40e9-8dca-7221c2acd627','08d9c356-5647-427f-8e52-196aefb750e5'),('03483eb7-ed45-4bec-91e3-1bc6494eeecd','63edec0a-49eb-4883-be74-1dffdb388c15','08d9c356-5647-427f-8e52-196aefb750e5'),('043677a8-d3d6-4679-a80a-2d54f5ed0a07','875a23bd-3d61-49f0-9cd3-03a5655f9f1d','08d9c356-5647-4219-84d9-657fac52d471'),('04f9340f-e7d5-4b9d-960f-7b52f0145d04','b62b7209-a822-487d-a368-c285971b4ede','08d9c356-5647-427f-8e52-196aefb750e5'),('073bbb4b-f545-46d9-ab15-1c8b6ec0df89','20619ea5-cd00-41cd-ac4a-829d26464c29','08d9c356-5647-427f-8e52-196aefb750e5'),('09328f39-1050-40a4-b55f-4233f0035090','7b15c899-4f69-4177-ab43-cceb104e4261','08d9c356-5647-427f-8e52-196aefb750e5'),('0db7018d-4fb9-4470-8169-336e2be98e15','10de1baa-4c0f-4cf2-90c7-81531fbcbe51','08d9c356-5647-4247-8653-404cfff08fc0'),('122ae5c6-0de8-4c36-9bee-53b3883d507e','dc6d61b0-e074-41a0-8689-4110a202b7cc','08d9c356-5647-427f-8e52-196aefb750e5'),('12909e47-1ae0-4d98-a230-945bd704b60b','eaf7a6a9-c495-4582-bd6b-7e7ab022e9e2','08d9c356-5647-427f-8e52-196aefb750e5'),('131a5c03-320b-4fa9-95f3-c127122e7062','aadb1695-5daf-4a71-a32b-1727fb92040b','08d9c356-5647-427f-8e52-196aefb750e5'),('1669cc8a-26d8-4370-9117-6dde3c16026f','e735e75f-5521-48f2-acea-7a9350e87b94','08d9c356-5647-427f-8e52-196aefb750e5'),('18a94643-eb3e-47ae-a2b8-863d1d0c07ac','6ad42e18-7e75-41d9-bdea-d89c7dc76e7a','08d9c356-5647-427f-8e52-196aefb750e5'),('1b142f68-43de-485d-aebf-687f49c14ca1','d6ae8b5a-e7ca-4399-b02e-4ee882237ba2','08d9c356-5647-427f-8e52-196aefb750e5'),('21c68a42-1c0f-46e8-b423-d473c3abfe45','9a03c468-c46c-49e3-beab-cdcf46e0f0ab','08d9c356-5647-4219-84d9-657fac52d471'),('22146d3d-468d-44dd-aa89-9824d2476831','734b2208-1830-46b4-94b4-53133f171354','08d9c356-5647-427f-8e52-196aefb750e5'),('230574b8-c06c-475d-953b-a9b150cc67ce','c350693f-dbe0-4ee0-9b16-3df0ed6de9ac','08d9c356-5647-427f-8e52-196aefb750e5'),('29353543-e42a-471c-a7f9-c65f59aa6d17','34247837-31a8-4aab-983e-945c4986b46c','08d9c356-5647-427f-8e52-196aefb750e5'),('2b49e860-a470-431a-8868-17820a5ba4ac','66d47d99-5ea2-414d-9ecd-0d089456f3ca','08d9c356-5647-427f-8e52-196aefb750e5'),('2dfa999c-6b2d-4f34-92f7-70663c17aee2','94bed3b2-5325-4122-835b-5ca72309dee6','08d9c356-5647-427f-8e52-196aefb750e5'),('2f25d759-2cf5-40cc-8e83-618226c2c010','770e016c-7354-4438-b781-8494bc56797b','08d9c356-5647-427f-8e52-196aefb750e5'),('31a8f624-7377-4ae9-ac54-704045746390','a5dbc9f1-1ea9-4a16-a369-a7051ba4766e','08d9c356-5647-427f-8e52-196aefb750e5'),('325f4808-48d7-4db0-aae0-a10c96bfc428','e40e65b3-8a78-4ebe-8566-8d62f57eae30','08d9c356-5647-427f-8e52-196aefb750e5'),('34b1039c-18fa-4968-9c2b-4d3c5c50c2da','7f9b7e1f-cd1f-4f89-af58-c7d73db60f44','08d9c356-5647-4247-8653-404cfff08fc0'),('364281e4-964d-4d0f-a187-e127a88b21cb','874126c7-654b-4928-91c1-a5c041b0edfe','08d9c356-5647-427f-8e52-196aefb750e5'),('36b7e87a-82ed-4ab4-b03e-320dd5b1060b','68ef38f0-eb06-4701-92f2-3d30bdf00498','08d9c356-5647-4247-8653-404cfff08fc0'),('37337e19-1d5d-4d63-a35a-c0666a134831','7a948bdd-3930-444c-a608-0600286b2e88','08d9c356-5647-427f-8e52-196aefb750e5'),('3933589b-53af-47e7-83e2-a79be5b597bc','f6800e6e-e5c2-4f3d-9215-404912b8b734','08d9c356-5647-427f-8e52-196aefb750e5'),('39b4e1a7-83c5-4d8f-ab7f-cf4e16032e29','5f7ee161-bde9-4247-85ce-ddd3e16a8da2','08d9c356-5647-4247-8653-404cfff08fc0'),('40b93451-b3df-4aac-8a64-074ef1a1026a','c57e7135-059f-40b5-be69-0483e26b90ae','08d9c356-5647-427f-8e52-196aefb750e5'),('40cbd5da-ab70-4c99-b9c0-4f59fc699a01','e0763d83-a8ec-4838-98d9-6eea74b9bf26','08d9c356-5647-427f-8e52-196aefb750e5'),('40dedf31-c7df-48c4-ba47-c3dd4b121f19','41328048-135c-46b5-a30b-74d00fccfe4d','08d9c356-5647-4247-8653-404cfff08fc0'),('4349c242-3962-4c5c-b586-01d47cf254fe','796ba9db-ed1e-470e-9544-c16302fb9446','08d9c356-5647-427f-8e52-196aefb750e5'),('43647f17-2a4f-4445-9b21-477e84b58dc4','fc9d6b75-cf91-486d-9aa8-03a0993b39ec','08d9c356-5647-427f-8e52-196aefb750e5'),('48374629-c1d4-4a40-bb69-3f199bed249f','4c745261-9139-4fc5-963e-6f6a37db7682','08d9c356-5647-427f-8e52-196aefb750e5'),('4aa98541-750a-42df-b71a-2991ed0ca949','2cff04b8-7a56-449c-adf3-3a37e6fe0487','08d9c356-5647-4219-84d9-657fac52d471'),('4e1fdfd6-a4ad-4630-a346-39c55213f4e1','cbc6f341-3d90-4aff-a987-397f2da5e25b','08d9c356-5647-427f-8e52-196aefb750e5'),('4eb46f57-52ad-41cc-837d-9a55c335d8ab','875a23bd-3d61-49f0-9cd3-03a5655f9f1d','08d9c356-5647-427f-8e52-196aefb750e5'),('54d545dd-613c-43b3-a04a-c71d9a4fe6e3','ba5ad2e6-0859-4a47-902f-22aabf8c269b','08d9c356-5647-427f-8e52-196aefb750e5'),('54f5e557-6cf9-472a-beb8-09e1077569e8','d2ac4c81-7ced-4c1b-bc28-00fa4c1c03a3','08d9c356-5647-427f-8e52-196aefb750e5'),('5593a2d5-e614-4bab-a6ea-1203b6622e8b','4d5ce3bf-d192-41ce-a3e4-a59a07a5961d','08d9c356-5647-427f-8e52-196aefb750e5'),('5828345d-1dac-46cf-a0b2-7d0e5f1d496a','1c4c8270-9c22-422b-b0b8-81c221a262e8','08d9c356-5647-427f-8e52-196aefb750e5'),('5dad309c-2045-41f6-9739-63d22de70ae5','415a8695-7515-45e4-9b78-a0b13d28e5df','08d9c356-5647-427f-8e52-196aefb750e5'),('62d03dca-afdf-4c52-9191-030fafdce317','87e7afc0-de73-47f6-b24b-997a1b420e49','08d9c356-5647-427f-8e52-196aefb750e5'),('6ac71608-3d35-43d7-94be-5c14836d722c','7302f713-8f48-4966-a602-a9684edfe818','08d9c356-5647-427f-8e52-196aefb750e5'),('6d36401a-0b4e-4002-9f58-3e95154d1898','fc87ebde-821a-4938-b715-39511329595b','08d9c356-5647-427f-8e52-196aefb750e5'),('6ded1424-50d3-433d-8995-9a69a2b582de','c5abd27f-3d5b-4b5f-baeb-f405656d11c3','08d9c356-5647-4247-8653-404cfff08fc0'),('6f60d3a6-f242-48f1-8592-a3af1145264a','a4170123-71e8-4bfa-91ee-5a5c3c16e543','08d9c356-5647-427f-8e52-196aefb750e5'),('72726177-6b97-4a7e-bdac-af8744bc0631','4d23f636-1198-4653-b225-749024c89c15','08d9c356-5647-427f-8e52-196aefb750e5'),('72d3c9ad-bd5e-46b8-abd5-dabb11d94810','3ba655b5-fca4-453a-b9c7-5356fd1b59fc','08d9c356-5647-427f-8e52-196aefb750e5'),('790e9acc-76fb-4dd1-8639-033ccd3a90c4','350254a5-4ef4-4142-851a-23ada94739a6','08d9c356-5647-427f-8e52-196aefb750e5'),('7a7a7bff-d23e-4dec-b95f-aab43f816ce1','a9cac001-76cb-4c7f-93ec-7679afc3d293','08d9c356-5647-427f-8e52-196aefb750e5'),('7b52fff7-38e2-4636-b364-a0c611e1111f','528d092d-a0ac-488b-9522-c711ec567caf','08d9c356-5647-427f-8e52-196aefb750e5'),('8059a920-e94e-4f89-8b5c-9d34db9658bf','3562c899-6e38-4289-961f-906035fe5548','08d9c356-5647-427f-8e52-196aefb750e5'),('827a383c-9354-4b8f-a094-85d6d312f803','bd8bdc65-6453-484e-985a-a3ec207d02b8','08d9c356-5647-4247-8653-404cfff08fc0'),('843fe09e-91ca-4309-a3c1-ff70142794cc','15edbd6e-187c-4c04-a380-d83825ef899f','08d9c356-5647-427f-8e52-196aefb750e5'),('85c5c3ad-99ca-4fc8-949f-2e926e1efef0','c770b6a2-0679-4994-b907-c033df921a76','08d9c356-5647-427f-8e52-196aefb750e5'),('863c4fff-aace-4dfd-a52f-49fd344c42e2','78d87239-c127-431a-b41c-c9314d8ce707','08d9c356-5647-427f-8e52-196aefb750e5'),('88e08d42-1005-49eb-b8bd-30d4d0267fb1','83adb48c-fb81-4f1f-9220-e0949835aff7','08d9c356-5647-427f-8e52-196aefb750e5'),('8e1fde15-c272-447e-8d0c-ae2ce24b2a21','45afcb5c-b041-4905-9bea-a447d050b1df','08d9c356-5647-427f-8e52-196aefb750e5'),('948c6cd4-6f88-4bf3-86d3-08b066b78568','d3a6862c-f791-4130-badd-2119c728ca50','08d9c356-5647-427f-8e52-196aefb750e5'),('9731e879-e8ea-4807-8c67-04c4755fee6f','d6b4357d-fe12-488b-a6b0-b387db8beba6','08d9c356-5647-427f-8e52-196aefb750e5'),('9a6624c5-0c6d-4c43-b252-cfb7fb54788b','14611de8-e7a2-40d1-9a2e-d33b82c180f0','08d9c356-5647-427f-8e52-196aefb750e5'),('9b97237e-18aa-4593-ae1a-a874eac557d1','e2d30931-43f4-4088-aa9b-4ce8098b05eb','08d9c356-5647-427f-8e52-196aefb750e5'),('9beb6944-c884-4da3-a278-41815029ecd0','c53073ad-003d-414a-be37-d9b04aad8368','08d9c356-5647-427f-8e52-196aefb750e5'),('a03358de-05eb-4ca9-935d-0d43123940ec','f480f547-7112-4488-83ea-6ecc2fa611dc','08d9c356-5647-427f-8e52-196aefb750e5'),('a21a5dd6-da79-4595-ae46-f8f7fe8a976d','3b156e11-8fa2-46e1-aeda-53bab972451e','08d9c356-5647-427f-8e52-196aefb750e5'),('a58413a2-4c4b-4428-aea7-3b567e6b0b42','d83d44b7-2e7b-4874-b3c9-6f9e189405cc','08d9c356-5647-427f-8e52-196aefb750e5'),('aa062cde-aa8c-482d-9988-2bb5fdbddbf1','1014e47b-21bd-4f1f-9a71-c46330f8fa37','08d9c356-5647-427f-8e52-196aefb750e5'),('ab4abc2a-f28b-4682-a40b-223e80021709','15edbd6e-187c-4c04-a380-d83825ef899f','08d9c356-5647-4219-84d9-657fac52d471'),('abc9859d-bcc4-478a-b1e1-a2d820f35811','a7a37837-1f79-4b3a-abda-485dbf033b1c','08d9c356-5647-427f-8e52-196aefb750e5'),('ad2e8f4c-286e-4aa9-853a-bb618a1473a1','6ea4ba21-dc6c-4c2d-aab8-9cd76eead618','08d9c356-5647-4247-8653-404cfff08fc0'),('adb77d13-0cf4-45b6-9394-d9c7e9e1d6b6','87c40ea2-1d51-4764-9aef-15c29c99cf78','08d9c356-5647-427f-8e52-196aefb750e5'),('adfb55f1-112b-469e-89b1-ba76de72f0b2','1925e1e1-b563-4680-9965-8815d0ba4c45','08d9c356-5647-427f-8e52-196aefb750e5'),('b2dbde3b-a7d7-4045-82ea-84927ee738f5','238ef535-4638-423f-a188-adf2d8799691','08d9c356-5647-427f-8e52-196aefb750e5'),('b3af437b-08ef-4d10-9f0a-e70783fee270','52fb6512-8fd9-4f6e-9834-dcd3c142735c','08d9c356-5647-427f-8e52-196aefb750e5'),('b406900e-bbd3-4f01-a8ac-98ccebb3f0f8','28b2a05c-e37d-45a2-a478-73b2689d62f5','08d9c356-5647-427f-8e52-196aefb750e5'),('b503ea0e-c820-46b3-a982-6b953001d956','b4563d9e-65d2-45f5-ba8d-65b9a40f5fe5','08d9c356-5647-427f-8e52-196aefb750e5'),('b546b17d-5ee6-4434-a8de-52e2fd797d29','83dbe7a5-d9e0-48d6-a66e-4b6f65831364','08d9c356-5647-427f-8e52-196aefb750e5'),('b8a05b9b-1c58-416b-baaa-dab23c01be41','b52804ad-e724-44af-8ee9-980c1cf013ce','08d9c356-5647-427f-8e52-196aefb750e5'),('b9481a18-b381-4242-8b2c-c344efe42547','62e30894-258a-4724-b584-468d8de32804','08d9c356-5647-427f-8e52-196aefb750e5'),('bc659e9d-903f-4d6a-9c4e-1c9ab1ec7772','b58a7116-0680-4ccd-be35-3987834b4bb0','08d9c356-5647-427f-8e52-196aefb750e5'),('beca59bc-1736-40d1-a287-a01958cd760d','7befc9bb-9ba2-419a-a2be-57119ff1a541','08d9c356-5647-427f-8e52-196aefb750e5'),('c1b0e3cc-c9fb-4053-9bb3-a2c8fbbbe89c','5820ad78-7074-4e7b-bb22-8d95a82993ef','08d9c356-5647-427f-8e52-196aefb750e5'),('c757d390-20e2-41a0-900e-c15ba9e30796','e97fd6c1-dde1-41fb-acc2-dcf84cc96db0','08d9c356-5647-427f-8e52-196aefb750e5'),('cd5115d2-aa10-4145-b1df-c7f0e309c84c','6aad186b-1e82-4fe3-97ab-0aaca9c8b9fc','08d9c356-5647-427f-8e52-196aefb750e5'),('ce82c3df-6ef5-4414-ada8-d553e223299f','1a483b1a-6a13-4bcb-a620-d1e009d346f5','08d9c356-5647-4247-8653-404cfff08fc0'),('d0a68562-5b85-42ec-bf4b-39372a195bbe','9a03c468-c46c-49e3-beab-cdcf46e0f0ab','08d9c356-5647-427f-8e52-196aefb750e5'),('d1e6adf0-a810-4fee-98a1-832945e5e182','717b7d03-9b43-456c-be24-3ca7c9f5e53e','08d9c356-5647-427f-8e52-196aefb750e5'),('d3ea0456-f902-465e-8358-6eb20a4cefad','0939f0e7-17fa-44da-b6d1-d73a91bfe168','08d9c356-5647-427f-8e52-196aefb750e5'),('d8ef85b7-222f-4622-adb1-73e0a32df015','51ecccf2-09c6-497c-be5d-608740747dd3','08d9c356-5647-427f-8e52-196aefb750e5'),('dae47040-a4e4-4788-b0b6-a74a716271f8','029e5ad6-35ab-4217-8ed2-b9c5a6fd1950','08d9c356-5647-427f-8e52-196aefb750e5'),('dc61bdf4-2141-4886-b1ca-5c171808d4d5','4cdf55d8-6388-4c67-9a3f-96f738e408a2','08d9c356-5647-427f-8e52-196aefb750e5'),('dcd8c575-359f-4544-8045-578db86981aa','2cff04b8-7a56-449c-adf3-3a37e6fe0487','08d9c356-5647-427f-8e52-196aefb750e5'),('e906f47d-1ff5-4b3e-88be-d65bc445f689','6987b297-5130-44bb-b2c0-1320b3390c93','08d9c356-5647-427f-8e52-196aefb750e5'),('ea98bacd-93e0-41f2-8417-44ed854643d9','b2b0bb3d-8cad-4abf-8c77-816d1c64099c','08d9c356-5647-4247-8653-404cfff08fc0'),('f17c76cd-27f0-4710-a4e4-fd312c217bc6','babc954a-941f-4e4e-979c-6452fee0ebe8','08d9c356-5647-427f-8e52-196aefb750e5'),('f34a5d89-c8b0-48e8-8872-3fe603bd2259','1fb6ae28-e984-46ad-a7f1-7b255e9486f5','08d9c356-5647-427f-8e52-196aefb750e5'),('f37094d8-72c6-44ea-a509-2f3088b4477c','5def466f-c513-446f-a82e-23ce3128299d','08d9c356-5647-4247-8653-404cfff08fc0'),('f52b6c11-a516-4075-8172-b3d8ed950e7c','bceaa683-9a97-4cde-9e92-56c8ad4ab743','08d9c356-5647-427f-8e52-196aefb750e5'),('f6406347-d472-4319-9597-1cfafdf63fd0','91b015bf-fca3-48e2-ae11-97a514a3da37','08d9c356-5647-427f-8e52-196aefb750e5'),('f76db8e2-f61c-49b7-a120-cdc637bc2f6b','038941b6-1611-4e08-b59a-36def6456b2a','08d9c356-5647-427f-8e52-196aefb750e5'),('f88f39e9-cc9a-49b0-870a-dcd8f0ce3e15','a3e86d2c-c17b-4b18-8a33-780d47de11b3','08d9c356-5647-4247-8653-404cfff08fc0'),('fa283152-1e7a-4001-aa23-7a1bd5d06ae2','a6056daf-e741-4c51-a41a-58fd27682001','08d9c356-5647-427f-8e52-196aefb750e5'),('fd5a9d35-9da6-4200-8014-b3b619a448d0','3599e786-959d-4b7a-82e9-9c67d7906e41','08d9c356-5647-427f-8e52-196aefb750e5');/*!40000 ALTER TABLE `appusewithapproles` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `commonaddresss`--DROP TABLE IF EXISTS `commonaddresss`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `commonaddresss` (  `Id` char(36) NOT NULL,  `Name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `Province` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,  `City` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,  `Region` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,  `Street` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,  `PostCode` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,  PRIMARY KEY (`Id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `commonaddresss`--LOCK TABLES `commonaddresss` WRITE;/*!40000 ALTER TABLE `commonaddresss` DISABLE KEYS */;INSERT INTO `commonaddresss` VALUES ('8adff1d6-bd8d-4f9c-a0ce-ca34eea25896','中国','云南','曲靖','七零区','鹧鸪江路8号','540000'),('e670c838-2f7d-4d7f-8a81-87463d19c49f','中国','云南','曲靖','七零区','鹧鸪江路8号','540000');/*!40000 ALTER TABLE `commonaddresss` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `financeitems`--DROP TABLE IF EXISTS `financeitems`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `financeitems` (  `Id` char(36) NOT NULL,  `Remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `PlanFunding` decimal(65,30) NOT NULL,  `ActualFunding` decimal(65,30) NOT NULL,  `ProjectTaskId` char(36) DEFAULT NULL,  `FinanceId` char(36) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `IX_FinanceItems_FinanceId` (`FinanceId`),  KEY `IX_FinanceItems_ProjectTaskId` (`ProjectTaskId`),  CONSTRAINT `FK_FinanceItems_Finances_FinanceId` FOREIGN KEY (`FinanceId`) REFERENCES `finances` (`Id`) ON DELETE RESTRICT,  CONSTRAINT `FK_FinanceItems_ProjectTasks_ProjectTaskId` FOREIGN KEY (`ProjectTaskId`) REFERENCES `projecttasks` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `financeitems`--LOCK TABLES `financeitems` WRITE;/*!40000 ALTER TABLE `financeitems` DISABLE KEYS */;INSERT INTO `financeitems` VALUES ('74765930-46ee-497f-947f-4c3235e9b2c6',' 财务条目备注',3.000000000000000000000000000000,1.000000000000000000000000000000,'98896bb4-1cc1-4cdd-ba91-7feeaad0a0e4','0740a8fc-b81c-46b9-ad96-060b6cbb9c91');/*!40000 ALTER TABLE `financeitems` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `finances`--DROP TABLE IF EXISTS `finances`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `finances` (  `Id` char(36) NOT NULL,  `Remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `PlanFunding` decimal(65,30) NOT NULL,  `ActualFunding` decimal(65,30) NOT NULL,  `ProjectId` char(36) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `IX_Finances_ProjectId` (`ProjectId`),  CONSTRAINT `FK_Finances_Projects_ProjectId` FOREIGN KEY (`ProjectId`) REFERENCES `projects` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `finances`--LOCK TABLES `finances` WRITE;/*!40000 ALTER TABLE `finances` DISABLE KEYS */;INSERT INTO `finances` VALUES ('0740a8fc-b81c-46b9-ad96-060b6cbb9c91',' 五憋住',12.000000000000000000000000000000,15.000000000000000000000000000000,'08d9c356-57e6-4e49-8b91-1e70ee1ec6f3');/*!40000 ALTER TABLE `finances` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `hospitaldepartmentdemands`--DROP TABLE IF EXISTS `hospitaldepartmentdemands`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `hospitaldepartmentdemands` (  `Id` char(36) NOT NULL,  `HospitalDepartmentId` char(36) DEFAULT NULL,  `DeclareReason` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `ApprovalRemarks` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `ApprovalPersonId` char(36) DEFAULT NULL,  `DemandDate` datetime(6) NOT NULL,  `ApprovalCompletedTime` datetime(6) NOT NULL,  `IsPass` tinyint(1) NOT NULL,  PRIMARY KEY (`Id`),  KEY `IX_HospitalDepartmentDemands_ApprovalPersonId` (`ApprovalPersonId`),  KEY `IX_HospitalDepartmentDemands_HospitalDepartmentId` (`HospitalDepartmentId`),  CONSTRAINT `FK_HospitalDepartmentDemands_OrganizationDepartments_HospitalDe~` FOREIGN KEY (`HospitalDepartmentId`) REFERENCES `organizationdepartments` (`Id`) ON DELETE RESTRICT,  CONSTRAINT `FK_HospitalDepartmentDemands_PurchasingLeadingGroupMebers_Appro~` FOREIGN KEY (`ApprovalPersonId`) REFERENCES `purchasingleadinggroupmebers` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `hospitaldepartmentdemands`--LOCK TABLES `hospitaldepartmentdemands` WRITE;/*!40000 ALTER TABLE `hospitaldepartmentdemands` DISABLE KEYS */;INSERT INTO `hospitaldepartmentdemands` VALUES ('46efa054-866d-4490-b6c2-4ad381856ff7','c12aac7a-130f-4425-afeb-7b2af4ebf0fe','我们缺少此机器','同意',NULL,'2021-12-19 00:00:00.000000','2021-12-29 00:00:00.000000',1);/*!40000 ALTER TABLE `hospitaldepartmentdemands` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `maintenancerecordss`--DROP TABLE IF EXISTS `maintenancerecordss`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `maintenancerecordss` (  `Id` char(36) NOT NULL,  `DownTime` datetime(6) NOT NULL,  `DownReason` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `RepairNotes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `RepairTime` datetime(6) NOT NULL,  `MedicalDeviceId` char(36) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `IX_MaintenanceRecordss_MedicalDeviceId` (`MedicalDeviceId`),  CONSTRAINT `FK_MaintenanceRecordss_MedicalDevices_MedicalDeviceId` FOREIGN KEY (`MedicalDeviceId`) REFERENCES `medicaldevices` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `maintenancerecordss`--LOCK TABLES `maintenancerecordss` WRITE;/*!40000 ALTER TABLE `maintenancerecordss` DISABLE KEYS */;INSERT INTO `maintenancerecordss` VALUES ('00377281-2616-4052-a0df-594e17aadfda','2021-12-20 09:16:26.170568','不知道诶','以后注意不要踢他','2021-12-20 09:16:26.170785','b792bb6e-daf0-4597-82ff-8f70dc5b4c1a');/*!40000 ALTER TABLE `maintenancerecordss` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `medicaldevices`--DROP TABLE IF EXISTS `medicaldevices`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `medicaldevices` (  `Id` char(36) NOT NULL,  `Name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `OwnerId` char(36) DEFAULT NULL,  `PurchasecCost` decimal(65,30) NOT NULL,  `VendorId` char(36) DEFAULT NULL,  `ServiceTime` datetime(6) NOT NULL,  `Brand` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `PutIntoUseTime` datetime(6) NOT NULL,  PRIMARY KEY (`Id`),  KEY `IX_MedicalDevices_OwnerId` (`OwnerId`),  KEY `IX_MedicalDevices_VendorId` (`VendorId`),  CONSTRAINT `FK_MedicalDevices_Tenants_OwnerId` FOREIGN KEY (`OwnerId`) REFERENCES `tenants` (`Id`) ON DELETE RESTRICT,  CONSTRAINT `FK_MedicalDevices_Tenants_VendorId` FOREIGN KEY (`VendorId`) REFERENCES `tenants` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `medicaldevices`--LOCK TABLES `medicaldevices` WRITE;/*!40000 ALTER TABLE `medicaldevices` DISABLE KEYS */;INSERT INTO `medicaldevices` VALUES ('b792bb6e-daf0-4597-82ff-8f70dc5b4c1a','X光机器','2de1cd24-b4ad-41b3-937b-62088b818ebe',13.000000000000000000000000000000,NULL,'2021-12-20 09:16:26.147523','大海','2021-12-20 09:16:26.147632');/*!40000 ALTER TABLE `medicaldevices` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `organizationdepartmentemployees`--DROP TABLE IF EXISTS `organizationdepartmentemployees`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `organizationdepartmentemployees` (  `Id` char(36) NOT NULL,  `Name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `IdentificationNumber` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,  `Birthday` datetime(6) NOT NULL,  `Sex` tinyint(1) NOT NULL,  `PhoneNumber` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,  `Email` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `WebChat` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,  `QQ` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,  `AppUserId` char(36) DEFAULT NULL,  `CommonAddressId` char(36) DEFAULT NULL,  `OrganizationDepartmentId` char(36) DEFAULT NULL,  `LaborContractExpirationTime` datetime(6) NOT NULL,  `EmergencyContact` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `EmergencyContactPhone` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `WorkNumber` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  PRIMARY KEY (`Id`),  KEY `IX_OrganizationDepartmentEmployees_AppUserId` (`AppUserId`),  KEY `IX_OrganizationDepartmentEmployees_CommonAddressId` (`CommonAddressId`),  KEY `IX_OrganizationDepartmentEmployees_OrganizationDepartmentId` (`OrganizationDepartmentId`),  CONSTRAINT `FK_OrganizationDepartmentEmployees_AppUsers_AppUserId` FOREIGN KEY (`AppUserId`) REFERENCES `appusers` (`Id`) ON DELETE RESTRICT,  CONSTRAINT `FK_OrganizationDepartmentEmployees_CommonAddresss_CommonAddress~` FOREIGN KEY (`CommonAddressId`) REFERENCES `commonaddresss` (`Id`) ON DELETE RESTRICT,  CONSTRAINT `FK_OrganizationDepartmentEmployees_OrganizationDepartments_Orga~` FOREIGN KEY (`OrganizationDepartmentId`) REFERENCES `organizationdepartments` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `organizationdepartmentemployees`--LOCK TABLES `organizationdepartmentemployees` WRITE;/*!40000 ALTER TABLE `organizationdepartmentemployees` DISABLE KEYS */;INSERT INTO `organizationdepartmentemployees` VALUES ('08d9c356-5713-4217-87c2-fa04abac0b35','555','330781198509077158','1998-11-16 00:00:00.000000',0,'13441412674','00201682403@163.com','13450610651','208441187','504ad0a2-6971-4126-891e-245ff090c5d8','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','948266730'),('08d9c356-5715-4660-8e28-72f97e081635','李园长','330781198509072234','1998-11-16 00:00:00.000000',0,'13427336427','80827427848@163.com','13417555481','227230158','504ad0a2-6971-4126-891e-245ff090c5d8','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','不止','8693576','946275860'),('08d9c356-5715-469f-8f18-379c97d44388','张霄','330781198509077270','1995-11-16 00:00:00.000000',0,'13400182860','00265086316@163.com','13405605708','220244568','36348229-87bd-4248-8237-e348b49392c2','e670c838-2f7d-4d7f-8a81-87463d19c49f','c12aac7a-130f-4425-afeb-7b2af4ebf0fe','2039-11-15 00:00:00.000000','不知道啊','8693576','947145763'),('08d9c356-5718-4108-8b18-a59cb0a002b6','赵 一 ','330781198509077158','1998-11-16 00:00:00.000000',0,'13482178886','03381580451@163.com','13452276477','217482256','2cff04b8-7a56-449c-adf3-3a37e6fe0487','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','974431368'),('08d9c356-571b-4242-8aaa-e9fd3c4c4fe9','赵 二','330781198509077158','1998-11-16 00:00:00.000000',0,'13478778542','51660376163@163.com','13465528221','267363718','9a03c468-c46c-49e3-beab-cdcf46e0f0ab','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','904786068'),('08d9c356-571c-4927-835f-64d8acee0e7d','赵 三','330781198509077158','1998-11-16 00:00:00.000000',0,'13434628187','76268165070@163.com','13438463506','211888556','875a23bd-3d61-49f0-9cd3-03a5655f9f1d','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','977162741'),('08d9c356-571e-41df-876c-26234a7732a7','赵 四','330781198509077158','1998-11-16 00:00:00.000000',0,'13425746583','76462051540@163.com','13426618083','202664536','15edbd6e-187c-4c04-a380-d83825ef899f','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','925110100'),('08d9c356-571f-4b81-8fa9-863d303648a3','赵 五','330781198509077158','1998-11-16 00:00:00.000000',0,'13456226382','84142314883@163.com','13406347672','250072518','c5abd27f-3d5b-4b5f-baeb-f405656d11c3','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','934465827'),('08d9c356-5721-43fb-85be-dc0a9940388c','赵 六','330781198509077158','1998-11-16 00:00:00.000000',0,'13416230430','60101450675@163.com','13481046367','237685361','5f7ee161-bde9-4247-85ce-ddd3e16a8da2','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','971141500'),('08d9c356-5722-4ed1-8fab-5b700fd5f788','赵 七','330781198509077158','1998-11-16 00:00:00.000000',0,'13473368553','63362014566@163.com','13451771416','267408538','68ef38f0-eb06-4701-92f2-3d30bdf00498','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','904616846'),('08d9c356-5724-46d4-8091-763ce2d7dbdc','赵 八','330781198509077158','1998-11-16 00:00:00.000000',0,'13486472023','02162768871@163.com','13461010600','275865018','7f9b7e1f-cd1f-4f89-af58-c7d73db60f44','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','937761451'),('08d9c356-5725-4dc7-83e8-0c14d8e0ba45','赵 九','330781198509077158','1998-11-16 00:00:00.000000',0,'13448483872','82323055033@163.com','13450188435','252305613','bd8bdc65-6453-484e-985a-a3ec207d02b8','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','972308235'),('08d9c356-5727-4483-8848-30da9dad7acc','赵 十','330781198509077158','1998-11-16 00:00:00.000000',0,'13418828845','38106415382@163.com','13474328317','217820701','1a483b1a-6a13-4bcb-a620-d1e009d346f5','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','988280860'),('08d9c356-5728-4cec-8c2a-ef8d05026d79','钱一 ','330781198509077158','1998-11-16 00:00:00.000000',0,'13481371482','42207477875@163.com','13461672745','272875042','a3e86d2c-c17b-4b18-8a33-780d47de11b3','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','957571865'),('08d9c356-572a-4585-899e-ef713e4a4e93','钱二','330781198509077158','1998-11-16 00:00:00.000000',0,'13465788066','73705401332@163.com','13470855453','241778723','41328048-135c-46b5-a30b-74d00fccfe4d','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','934052423'),('08d9c356-572b-4e20-8cd3-5476404b6c8d','钱三','330781198509077158','1998-11-16 00:00:00.000000',0,'13476420575','46465402375@163.com','13415675333','254873683','5def466f-c513-446f-a82e-23ce3128299d','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','988278008'),('08d9c356-572d-4a40-883b-beb04aea4149','钱四','330781198509077158','1998-11-16 00:00:00.000000',0,'13438018567','82130143512@163.com','13428725441','275834104','b2b0bb3d-8cad-4abf-8c77-816d1c64099c','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','958331301'),('08d9c356-572f-4522-8153-b123b1a51060','钱五','330781198509077158','1998-11-16 00:00:00.000000',0,'13480336218','73213745043@163.com','13418504468','222555558','10de1baa-4c0f-4cf2-90c7-81531fbcbe51','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','944378712'),('08d9c356-5730-4f2e-830f-a3ef488f17ea','钱六','330781198509077158','1998-11-16 00:00:00.000000',0,'13423644810','02604352537@163.com','13402684443','245435866','6ea4ba21-dc6c-4c2d-aab8-9cd76eead618','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','982287565'),('08d9c356-5732-4998-8ee7-f788e06ef0a8','钱七','330781198509077158','1998-11-16 00:00:00.000000',0,'13456775407','53434526823@163.com','13441777141','215156884','dc6d61b0-e074-41a0-8689-4110a202b7cc','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','957421501'),('08d9c356-5734-476b-8498-48ce3f18a146','钱八','330781198509077158','1998-11-16 00:00:00.000000',0,'13418813550','60331742015@163.com','13446657048','287568256','a7a37837-1f79-4b3a-abda-485dbf033b1c','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','905678364'),('08d9c356-5736-43d8-8c71-52a9a51c4975','钱九','330781198509077158','1998-11-16 00:00:00.000000',0,'13470428015','01857708364@163.com','13487872461','217654178','7b15c899-4f69-4177-ab43-cceb104e4261','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','928102360'),('08d9c356-5738-41a8-8275-035b5de6c310','钱十','330781198509077158','1998-11-16 00:00:00.000000',0,'13478668863','54300106788@163.com','13462866226','231867207','83dbe7a5-d9e0-48d6-a66e-4b6f65831364','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','911042142'),('08d9c356-5739-4f1c-8565-078e891edb03','孙一 ','330781198509077158','1998-11-16 00:00:00.000000',0,'13484531276','67132447133@163.com','13466245707','225230083','d2ac4c81-7ced-4c1b-bc28-00fa4c1c03a3','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','966515145'),('08d9c356-573b-4cab-89e2-8cecb0a71877','孙二','330781198509077158','1998-11-16 00:00:00.000000',0,'13475828130','81354503780@163.com','13416877771','205257623','34247837-31a8-4aab-983e-945c4986b46c','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','982578538'),('08d9c356-573d-4aab-8f77-6e929d391c35','孙三','330781198509077158','1998-11-16 00:00:00.000000',0,'13431735187','38752532764@163.com','13402272160','225333641','83adb48c-fb81-4f1f-9220-e0949835aff7','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','945838408'),('08d9c356-573f-467c-8de3-75a55f3eb5dd','孙四','330781198509077158','1998-11-16 00:00:00.000000',0,'13480637543','63348835643@163.com','13467260832','254204685','7908fca3-22cc-40e9-8dca-7221c2acd627','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','946027832'),('08d9c356-5741-4727-8d71-02f5beead493','孙五','330781198509077158','1998-11-16 00:00:00.000000',0,'13435328418','13133677112@163.com','13418807778','246006213','717b7d03-9b43-456c-be24-3ca7c9f5e53e','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','946554870'),('08d9c356-5743-4410-8407-c1122edaee10','孙六','330781198509077158','1998-11-16 00:00:00.000000',0,'13457120083','52073868224@163.com','13467681863','261215673','415a8695-7515-45e4-9b78-a0b13d28e5df','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','933351323'),('08d9c356-5745-40ae-86ca-12de6c7d0187','孙七','330781198509077158','1998-11-16 00:00:00.000000',0,'13446005287','07580628838@163.com','13438577738','211134218','350254a5-4ef4-4142-851a-23ada94739a6','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','965317862'),('08d9c356-5747-405a-82f5-56421b27a8ac','孙八','330781198509077158','1998-11-16 00:00:00.000000',0,'13446304544','54048313685@163.com','13483300541','216283323','e735e75f-5521-48f2-acea-7a9350e87b94','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','948353045'),('08d9c356-5748-4d30-802a-73b9f54e4aea','孙九','330781198509077158','1998-11-16 00:00:00.000000',0,'13475200530','22215455247@163.com','13418151710','252642202','7a948bdd-3930-444c-a608-0600286b2e88','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','932505750'),('08d9c356-574a-4866-8110-09065d72e0c3','孙十','330781198509077158','1998-11-16 00:00:00.000000',0,'13418327067','66436113531@163.com','13430301203','230477163','4d5ce3bf-d192-41ce-a3e4-a59a07a5961d','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','906116311'),('08d9c356-574c-447c-839b-6a48dd1778b4','李一 ','330781198509077158','1998-11-16 00:00:00.000000',0,'13473172422','44872657818@163.com','13475413125','252502750','63edec0a-49eb-4883-be74-1dffdb388c15','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','933374226'),('08d9c356-574e-4257-81a4-ed596b0c942f','李二','330781198509077158','1998-11-16 00:00:00.000000',0,'13448158082','26075153263@163.com','13487881067','247326607','d3a6862c-f791-4130-badd-2119c728ca50','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','976146635'),('08d9c356-5750-4133-8bee-c4fc05748562','李三','330781198509077158','1998-11-16 00:00:00.000000',0,'13481687654','01424123235@163.com','13412314682','230548774','528d092d-a0ac-488b-9522-c711ec567caf','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','923334735'),('08d9c356-5753-4e58-8d90-28a8cf8ef47e','李四','330781198509077158','1998-11-16 00:00:00.000000',0,'13481086052','67035277844@163.com','13457788344','227676352','a6056daf-e741-4c51-a41a-58fd27682001','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','966385448'),('08d9c356-5756-44bd-8b82-44b3ad80c35c','李五','330781198509077158','1998-11-16 00:00:00.000000',0,'13403448613','47780767388@163.com','13437628103','273502124','f6800e6e-e5c2-4f3d-9215-404912b8b734','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','938578875'),('08d9c356-5758-4286-80af-c23a765135a6','李六','330781198509077158','1998-11-16 00:00:00.000000',0,'13471864447','52634452406@163.com','13423816150','262252047','3599e786-959d-4b7a-82e9-9c67d7906e41','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','914087485'),('08d9c356-5759-4ea5-8b10-4209970ad0be','李七','330781198509077158','1998-11-16 00:00:00.000000',0,'13458434364','80333140422@163.com','13405855284','242840755','1fb6ae28-e984-46ad-a7f1-7b255e9486f5','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','927030485'),('08d9c356-575b-4af2-824e-74800c938bc7','李八','330781198509077158','1998-11-16 00:00:00.000000',0,'13450865023','00827077548@163.com','13453627563','235512575','0939f0e7-17fa-44da-b6d1-d73a91bfe168','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','983001364'),('08d9c356-575d-4882-8610-4213001c0087','李九','330781198509077158','1998-11-16 00:00:00.000000',0,'13487161875','35700820088@163.com','13423634436','208707262','3b156e11-8fa2-46e1-aeda-53bab972451e','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','925416774'),('08d9c356-575f-4804-8c54-3ca1d079119e','李十','330781198509077158','1998-11-16 00:00:00.000000',0,'13453437801','76543356841@163.com','13445253428','216168050','a4170123-71e8-4bfa-91ee-5a5c3c16e543','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','918350281'),('08d9c356-5761-4580-8c28-92e5319ff134','周一 ','330781198509077158','1998-11-16 00:00:00.000000',0,'13418133274','76400253105@163.com','13470466424','230843218','45afcb5c-b041-4905-9bea-a447d050b1df','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','950328271'),('08d9c356-5763-4474-8f4f-ddc3ce6595b9','周二','330781198509077158','1998-11-16 00:00:00.000000',0,'13413043137','84804138463@163.com','13460562584','281674457','87e7afc0-de73-47f6-b24b-997a1b420e49','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','920261253'),('08d9c356-5765-4acb-8ef1-724ce524acd1','周三','330781198509077158','1998-11-16 00:00:00.000000',0,'13454175113','71720576601@163.com','13483481414','200170685','734b2208-1830-46b4-94b4-53133f171354','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','985463764'),('08d9c356-5768-4160-8f60-98ac80460646','周四','330781198509077158','1998-11-16 00:00:00.000000',0,'13468015188','62310423821@163.com','13437215320','270360872','bceaa683-9a97-4cde-9e92-56c8ad4ab743','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','921121285'),('08d9c356-576a-4a69-8a3b-4cf4d8fe29e5','周五','330781198509077158','1998-11-16 00:00:00.000000',0,'13468721568','72050287200@163.com','13480828352','202337472','7302f713-8f48-4966-a602-a9684edfe818','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','946066156'),('08d9c356-576c-4be6-86b2-6ad2fe3502fd','周六','330781198509077158','1998-11-16 00:00:00.000000',0,'13445381377','82807825508@163.com','13406572414','225837833','91b015bf-fca3-48e2-ae11-97a514a3da37','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','943782458'),('08d9c356-576e-49df-8c33-141a4e5e8df6','周七','330781198509077158','1998-11-16 00:00:00.000000',0,'13462063574','74122426338@163.com','13474508683','221543340','78d87239-c127-431a-b41c-c9314d8ce707','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','963516605'),('08d9c356-5770-48c8-8a61-26358f94648b','周八','330781198509077158','1998-11-16 00:00:00.000000',0,'13440776585','77518208348@163.com','13432753458','240273158','cbc6f341-3d90-4aff-a987-397f2da5e25b','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','972647741'),('08d9c356-5772-4d31-8916-179e3f9967d7','周九','330781198509077158','1998-11-16 00:00:00.000000',0,'13433611478','07116076755@163.com','13430604508','274102706','e0763d83-a8ec-4838-98d9-6eea74b9bf26','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','907566634'),('08d9c356-5775-46ef-8341-f3d1b3e4bcfc','周十','330781198509077158','1998-11-16 00:00:00.000000',0,'13474082773','10160800080@163.com','13480205234','271186801','c53073ad-003d-414a-be37-d9b04aad8368','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','923152268'),('08d9c356-5777-4b9e-82ce-eee52602b25f','吴一 ','330781198509077158','1998-11-16 00:00:00.000000',0,'13457868071','16178521656@163.com','13433644120','253680248','e2d30931-43f4-4088-aa9b-4ce8098b05eb','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','917280206'),('08d9c356-5779-4ead-8070-039230895dd7','吴二','330781198509077158','1998-11-16 00:00:00.000000',0,'13484725460','54223484660@163.com','13445780436','251638645','b52804ad-e724-44af-8ee9-980c1cf013ce','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','972688307'),('08d9c356-577c-4231-8a1c-638925efa702','吴三','330781198509077158','1998-11-16 00:00:00.000000',0,'13488887705','55074117606@163.com','13412376134','215533483','51ecccf2-09c6-497c-be5d-608740747dd3','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','924848262'),('08d9c356-577e-45c1-8bb0-1670d2b473d4','吴四','330781198509077158','1998-11-16 00:00:00.000000',0,'13447605271','54072466255@163.com','13430508657','204225564','f480f547-7112-4488-83ea-6ecc2fa611dc','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','902437653'),('08d9c356-5780-4a9f-8edb-af185151e644','吴五','330781198509077158','1998-11-16 00:00:00.000000',0,'13458148363','07218447817@163.com','13455683754','276374625','238ef535-4638-423f-a188-adf2d8799691','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','955151210'),('08d9c356-5782-4bcc-81ba-6aa8fea8f6a0','吴六','330781198509077158','1998-11-16 00:00:00.000000',0,'13438466075','28016173335@163.com','13473577030','262512221','029e5ad6-35ab-4217-8ed2-b9c5a6fd1950','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','930635757'),('08d9c356-5784-4b82-8806-03f6a7855f71','吴七','330781198509077158','1998-11-16 00:00:00.000000',0,'13403072852','68353164621@163.com','13483236106','260536158','aadb1695-5daf-4a71-a32b-1727fb92040b','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','943675061'),('08d9c356-5786-48c0-85f0-a21b26980d94','吴八','330781198509077158','1998-11-16 00:00:00.000000',0,'13423536537','18238770283@163.com','13408551838','271014526','20619ea5-cd00-41cd-ac4a-829d26464c29','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','947543620'),('08d9c356-5788-45f8-85b5-3c845b214739','吴九','330781198509077158','1998-11-16 00:00:00.000000',0,'13453215684','00460355875@163.com','13448876306','235245245','1925e1e1-b563-4680-9965-8815d0ba4c45','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','950501420'),('08d9c356-578a-4142-8367-7359cc1eb2ee','吴十','330781198509077158','1998-11-16 00:00:00.000000',0,'13445478844','53471325742@163.com','13473722600','226804117','62e30894-258a-4724-b584-468d8de32804','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','937522047'),('08d9c356-578b-4fc3-8f62-bd1c757e8e83','郑一 ','330781198509077158','1998-11-16 00:00:00.000000',0,'13487751880','47213725723@163.com','13454731244','245310721','d6ae8b5a-e7ca-4399-b02e-4ee882237ba2','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','922654378'),('08d9c356-578d-4ce7-809f-e44e6a205208','郑二','330781198509077158','1998-11-16 00:00:00.000000',0,'13437311016','38246250721@163.com','13424022888','265380522','c770b6a2-0679-4994-b907-c033df921a76','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','945565615'),('08d9c356-578f-48fc-8df1-ba902cc57d0e','郑三','330781198509077158','1998-11-16 00:00:00.000000',0,'13432460760','58306837720@163.com','13441038608','288643372','b58a7116-0680-4ccd-be35-3987834b4bb0','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','945457028'),('08d9c356-5791-45c3-84c0-c5cb70e7e76e','郑四','330781198509077158','1998-11-16 00:00:00.000000',0,'13477385225','48508585636@163.com','13410501560','238610005','3ba655b5-fca4-453a-b9c7-5356fd1b59fc','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','968154128'),('08d9c356-5793-41a1-8568-d6142e023037','郑五','330781198509077158','1998-11-16 00:00:00.000000',0,'13406227884','33173022573@163.com','13426245525','224324337','6aad186b-1e82-4fe3-97ab-0aaca9c8b9fc','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','916874543'),('08d9c356-5794-4d35-86f9-7884d9dffb6a','郑六','330781198509077158','1998-11-16 00:00:00.000000',0,'13426330501','15173535438@163.com','13487180003','273524680','4d23f636-1198-4653-b225-749024c89c15','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','976423840'),('08d9c356-5796-48cb-80f0-f66da15971ae','郑七','330781198509077158','1998-11-16 00:00:00.000000',0,'13443646243','13036066577@163.com','13413425416','202642767','796ba9db-ed1e-470e-9544-c16302fb9446','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','910626452'),('08d9c356-5798-4645-811d-560331bad4fb','郑八','330781198509077158','1998-11-16 00:00:00.000000',0,'13434411621','82264303153@163.com','13415577760','214524353','6ad42e18-7e75-41d9-bdea-d89c7dc76e7a','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','983015447'),('08d9c356-579a-45e4-8199-e8b6f9932a5e','郑九','330781198509077158','1998-11-16 00:00:00.000000',0,'13452141762','51067474873@163.com','13400012880','203281404','14611de8-e7a2-40d1-9a2e-d33b82c180f0','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','962724443'),('08d9c356-579c-45a8-8215-8b676018f57a','郑十','330781198509077158','1998-11-16 00:00:00.000000',0,'13472660241','27272141840@163.com','13438884518','257530710','28b2a05c-e37d-45a2-a478-73b2689d62f5','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','940867687'),('08d9c356-579e-4800-8490-bd6c307d6f9b','王一 ','330781198509077158','1998-11-16 00:00:00.000000',0,'13474531843','11622338106@163.com','13421863178','225501572','ba5ad2e6-0859-4a47-902f-22aabf8c269b','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','908145546'),('08d9c356-57a0-47c6-800d-cd1da216e3e6','王二','330781198509077158','1998-11-16 00:00:00.000000',0,'13422338352','88728683117@163.com','13406158400','206186662','87c40ea2-1d51-4764-9aef-15c29c99cf78','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','963075361'),('08d9c356-57a2-4539-89a7-02abbffd46de','王三','330781198509077158','1998-11-16 00:00:00.000000',0,'13488880865','18708740716@163.com','13418140783','256517166','1c4c8270-9c22-422b-b0b8-81c221a262e8','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','960570856'),('08d9c356-57a4-4587-80ab-6b09bc395df1','王四','330781198509077158','1998-11-16 00:00:00.000000',0,'13406275377','03523015687@163.com','13415148425','236778314','b4563d9e-65d2-45f5-ba8d-65b9a40f5fe5','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','978788782'),('08d9c356-57a6-4b95-8c21-4e15daed22e9','王五','330781198509077158','1998-11-16 00:00:00.000000',0,'13462773405','02672210605@163.com','13463638701','213345041','c57e7135-059f-40b5-be69-0483e26b90ae','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','974664741'),('08d9c356-57a8-4c96-87d6-1144a697d729','王六','330781198509077158','1998-11-16 00:00:00.000000',0,'13413811083','00813616080@163.com','13481606614','220351477','7befc9bb-9ba2-419a-a2be-57119ff1a541','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','913055785'),('08d9c356-57aa-4bf3-837d-d9ec266150cc','王七','330781198509077158','1998-11-16 00:00:00.000000',0,'13466800044','45040510331@163.com','13407311677','201307575','770e016c-7354-4438-b781-8494bc56797b','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','960544580'),('08d9c356-57ac-4b65-8eac-32680a51bc41','王八','330781198509077158','1998-11-16 00:00:00.000000',0,'13410766487','50723372528@163.com','13456675317','261247614','d6b4357d-fe12-488b-a6b0-b387db8beba6','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','954040673'),('08d9c356-57ae-48ea-81ef-bf4da4682ac9','王九','330781198509077158','1998-11-16 00:00:00.000000',0,'13413443421','53856386574@163.com','13476132681','218200475','eaf7a6a9-c495-4582-bd6b-7e7ab022e9e2','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','962787066'),('08d9c356-57b0-4876-84f0-1c177a5efb94','王十','330781198509077158','1998-11-16 00:00:00.000000',0,'13421004505','00560174187@163.com','13412155216','201452022','fc9d6b75-cf91-486d-9aa8-03a0993b39ec','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','943301540'),('08d9c356-57b2-4832-87b0-a97a7b5e57e1','刘一 ','330781198509077158','1998-11-16 00:00:00.000000',0,'13436788620','78884210442@163.com','13460857687','245482411','fc87ebde-821a-4938-b715-39511329595b','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','945845776'),('08d9c356-57b4-45ae-86ed-639545a89af5','刘二','330781198509077158','1998-11-16 00:00:00.000000',0,'13440518117','05644122885@163.com','13475270621','227587325','4cdf55d8-6388-4c67-9a3f-96f738e408a2','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','953885137'),('08d9c356-57b6-4284-844f-9f61d5f635c7','刘三','330781198509077158','1998-11-16 00:00:00.000000',0,'13480166228','54764552110@163.com','13444558516','251872450','1014e47b-21bd-4f1f-9a71-c46330f8fa37','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','964826801'),('08d9c356-57b7-4ffa-8f5a-2fdbc1d18beb','刘四','330781198509077158','1998-11-16 00:00:00.000000',0,'13402681848','78248556666@163.com','13475483682','253624160','94bed3b2-5325-4122-835b-5ca72309dee6','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','927555052'),('08d9c356-57b9-4ed6-87b2-f38bab85fa7c','刘五','330781198509077158','1998-11-16 00:00:00.000000',0,'13414113488','14688271033@163.com','13412553284','248481214','5820ad78-7074-4e7b-bb22-8d95a82993ef','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','933006845'),('08d9c356-57bd-457c-81fe-2ea1ade237b3','刘六','330781198509077158','1998-11-16 00:00:00.000000',0,'13476667582','73281112847@163.com','13432280718','218310468','d83d44b7-2e7b-4874-b3c9-6f9e189405cc','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','922412620'),('08d9c356-57bf-448b-8df7-9026f3436849','刘七','330781198509077158','1998-11-16 00:00:00.000000',0,'13470183302','55410883263@163.com','13468086176','244602322','e97fd6c1-dde1-41fb-acc2-dcf84cc96db0','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','934028650'),('08d9c356-57c1-415b-8bc1-845ceb498b61','刘八','330781198509077158','1998-11-16 00:00:00.000000',0,'13455766228','53734416127@163.com','13420560750','233213383','3562c899-6e38-4289-961f-906035fe5548','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','987676856'),('08d9c356-57c3-4009-83e8-5b5f5ad96624','刘九','330781198509077158','1998-11-16 00:00:00.000000',0,'13471773758','42305245807@163.com','13405848576','285003161','a9cac001-76cb-4c7f-93ec-7679afc3d293','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','932524848'),('08d9c356-57c5-422d-8c75-a18040749c1b','刘十','330781198509077158','1998-11-16 00:00:00.000000',0,'13426421342','86048364052@163.com','13403012614','211024158','6987b297-5130-44bb-b2c0-1320b3390c93','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','937748611'),('08d9c356-57c7-4164-867b-07eeb5463c0c','韦一 ','330781198509077158','1998-11-16 00:00:00.000000',0,'13410416432','02737076582@163.com','13425182630','231557453','52fb6512-8fd9-4f6e-9834-dcd3c142735c','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','906840635'),('08d9c356-57c9-4915-8bba-f1263ac79706','韦二','330781198509077158','1998-11-16 00:00:00.000000',0,'13480751032','34073500627@163.com','13488227867','270147140','a5dbc9f1-1ea9-4a16-a369-a7051ba4766e','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','936820667'),('08d9c356-57cb-49f6-839c-6011fd8b6f53','韦三','330781198509077158','1998-11-16 00:00:00.000000',0,'13434178488','32206806313@163.com','13424622635','263727180','038941b6-1611-4e08-b59a-36def6456b2a','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','940554228'),('08d9c356-57cd-46ff-8094-060e95597e45','韦四','330781198509077158','1998-11-16 00:00:00.000000',0,'13402418820','53428060211@163.com','13457518667','284615284','c350693f-dbe0-4ee0-9b16-3df0ed6de9ac','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','976811165'),('08d9c356-57cf-447d-8b80-fb0ce48785cc','韦五','330781198509077158','1998-11-16 00:00:00.000000',0,'13416517816','26420381688@163.com','13410031883','234780607','4c745261-9139-4fc5-963e-6f6a37db7682','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','923523686'),('08d9c356-57d1-44b3-88e2-10d0e08eba7a','韦六','330781198509077158','1998-11-16 00:00:00.000000',0,'13420458637','76502187410@163.com','13484201516','274427740','e40e65b3-8a78-4ebe-8566-8d62f57eae30','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','984327086'),('08d9c356-57d3-44ac-857a-f9419c4d6db5','韦七','330781198509077158','1998-11-16 00:00:00.000000',0,'13457370611','57031882406@163.com','13487817134','248212342','b62b7209-a822-487d-a368-c285971b4ede','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','970656761'),('08d9c356-57d5-4210-8f2f-539a59e242cd','韦八','330781198509077158','1998-11-16 00:00:00.000000',0,'13445016810','07068646675@163.com','13405280106','225413161','874126c7-654b-4928-91c1-a5c041b0edfe','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','912828201'),('08d9c356-57d6-4f4c-8e3e-bc2540e7effd','韦九','330781198509077158','1998-11-16 00:00:00.000000',0,'13488435213','32367032132@163.com','13417164203','254045208','babc954a-941f-4e4e-979c-6452fee0ebe8','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','930358841'),('08d9c356-57d8-4d79-8b33-e3837c3121d5','韦十','330781198509077158','1998-11-16 00:00:00.000000',0,'13407238436','85435183200@163.com','13400772071','212201426','66d47d99-5ea2-414d-9ecd-0d089456f3ca','e670c838-2f7d-4d7f-8a81-87463d19c49f',NULL,'2039-11-15 00:00:00.000000','乔','555','907856512');/*!40000 ALTER TABLE `organizationdepartmentemployees` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `organizationdepartments`--DROP TABLE IF EXISTS `organizationdepartments`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `organizationdepartments` (  `Id` char(36) NOT NULL,  `Name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `ResponseEmployee` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `OrganizationId` char(36) DEFAULT NULL,  `ParentId` char(36) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `IX_OrganizationDepartments_OrganizationId` (`OrganizationId`),  KEY `IX_OrganizationDepartments_ParentId` (`ParentId`),  CONSTRAINT `FK_OrganizationDepartments_OrganizationDepartments_ParentId` FOREIGN KEY (`ParentId`) REFERENCES `organizationdepartments` (`Id`) ON DELETE RESTRICT,  CONSTRAINT `FK_OrganizationDepartments_Organizations_OrganizationId` FOREIGN KEY (`OrganizationId`) REFERENCES `organizations` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `organizationdepartments`--LOCK TABLES `organizationdepartments` WRITE;/*!40000 ALTER TABLE `organizationdepartments` DISABLE KEYS */;INSERT INTO `organizationdepartments` VALUES ('05c20eed-e70b-4acc-88d9-8deb99c8e974','临床检验科','钱一 ','7711943c-6003-4381-8401-cf22e29b8d2c','faeb30e0-6093-4e18-bdc8-27eddf7c002f'),('0d0a464a-d47d-42a9-b126-30a22670ac60','药剂科','赵 九','7711943c-6003-4381-8401-cf22e29b8d2c','faeb30e0-6093-4e18-bdc8-27eddf7c002f'),('121e3540-1d7f-48e3-8585-6ecd493940e2','外科','赵 六','7711943c-6003-4381-8401-cf22e29b8d2c','29e967b4-2769-4092-b39f-fbe483f82ce9'),('1307f5a7-1547-4936-aa82-6e7fcc28544d','放射科','赵 十','7711943c-6003-4381-8401-cf22e29b8d2c','faeb30e0-6093-4e18-bdc8-27eddf7c002f'),('282fdcb8-c753-4bac-aac4-29eab3aa26e2','医务科','钱三','7711943c-6003-4381-8401-cf22e29b8d2c','5d54dd37-0a6a-4c8c-bf82-c9e0bde44c26'),('29e967b4-2769-4092-b39f-fbe483f82ce9','诊疗部','赵 一 ','7711943c-6003-4381-8401-cf22e29b8d2c',NULL),('5d54dd37-0a6a-4c8c-bf82-c9e0bde44c26','行政后勤部','赵 四','7711943c-6003-4381-8401-cf22e29b8d2c',NULL),('79d2df6a-9cee-4495-a87e-8d925bfc4676','病理科','钱二','7711943c-6003-4381-8401-cf22e29b8d2c','faeb30e0-6093-4e18-bdc8-27eddf7c002f'),('92274bdf-fc18-4c77-891a-3083752f49a1','妇产科','赵 七','7711943c-6003-4381-8401-cf22e29b8d2c','29e967b4-2769-4092-b39f-fbe483f82ce9'),('a6f980c5-10ef-42fc-9508-5aeee014c12d','护理部','赵 三','7711943c-6003-4381-8401-cf22e29b8d2c',NULL),('aea33f65-e892-4770-9172-958a7daa8bb4','人事科','钱四','7711943c-6003-4381-8401-cf22e29b8d2c','5d54dd37-0a6a-4c8c-bf82-c9e0bde44c26'),('c0febbe8-e6da-453a-a1fc-0e426730aa99','内科','赵 五','7711943c-6003-4381-8401-cf22e29b8d2c','29e967b4-2769-4092-b39f-fbe483f82ce9'),('c12aac7a-130f-4425-afeb-7b2af4ebf0fe','疗诊部','张霄','7711943c-6003-4381-8401-cf22e29b8d2c',NULL),('d9389a02-1726-46b3-837c-017e2bcf9704','财务科','钱五','7711943c-6003-4381-8401-cf22e29b8d2c','5d54dd37-0a6a-4c8c-bf82-c9e0bde44c26'),('df63e966-7867-454a-bd8b-46991a26b37a','儿科','赵 八','7711943c-6003-4381-8401-cf22e29b8d2c','29e967b4-2769-4092-b39f-fbe483f82ce9'),('f1c382d8-682e-44b0-8f82-8d98ffcc3a0d','科教科','钱六','7711943c-6003-4381-8401-cf22e29b8d2c','5d54dd37-0a6a-4c8c-bf82-c9e0bde44c26'),('faeb30e0-6093-4e18-bdc8-27eddf7c002f','辅助诊疗部','赵 二','7711943c-6003-4381-8401-cf22e29b8d2c',NULL);/*!40000 ALTER TABLE `organizationdepartments` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `organizationdepartmentwithorganizationdepartmentemployees`--DROP TABLE IF EXISTS `organizationdepartmentwithorganizationdepartmentemployees`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `organizationdepartmentwithorganizationdepartmentemployees` (  `Id` char(36) NOT NULL,  `OrganizationDepartmentId` char(36) DEFAULT NULL,  `OrganizationDepartmentEmployeeId` char(36) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `IX_OrganizationDepartmentWithOrganizationDepartmentEmployees_Or~` (`OrganizationDepartmentEmployeeId`),  KEY `IX_OrganizationDepartmentWithOrganizationDepartmentEmployees_O~1` (`OrganizationDepartmentId`),  CONSTRAINT `FK_OrganizationDepartmentWithOrganizationDepartmentEmployees_Or~` FOREIGN KEY (`OrganizationDepartmentEmployeeId`) REFERENCES `organizationdepartmentemployees` (`Id`) ON DELETE RESTRICT,  CONSTRAINT `FK_OrganizationDepartmentWithOrganizationDepartmentEmployees_O~1` FOREIGN KEY (`OrganizationDepartmentId`) REFERENCES `organizationdepartments` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `organizationdepartmentwithorganizationdepartmentemployees`--LOCK TABLES `organizationdepartmentwithorganizationdepartmentemployees` WRITE;/*!40000 ALTER TABLE `organizationdepartmentwithorganizationdepartmentemployees` DISABLE KEYS */;INSERT INTO `organizationdepartmentwithorganizationdepartmentemployees` VALUES ('013ac737-e299-4eea-a157-cc98a8d77831','aea33f65-e892-4770-9172-958a7daa8bb4','08d9c356-57aa-4bf3-837d-d9ec266150cc'),('05f4799d-2719-4692-89a5-107ebe0eb274','79d2df6a-9cee-4495-a87e-8d925bfc4676','08d9c356-5739-4f1c-8565-078e891edb03'),('0981da37-6506-4912-a65f-5e33dd6e2114','a6f980c5-10ef-42fc-9508-5aeee014c12d','08d9c356-571c-4927-835f-64d8acee0e7d'),('0d0041dc-ff31-4002-9dc5-b32fa124ad1c','0d0a464a-d47d-42a9-b126-30a22670ac60','08d9c356-576c-4be6-86b2-6ad2fe3502fd'),('0f2e942a-aea0-4d0f-92ae-410bdab00e49','c0febbe8-e6da-453a-a1fc-0e426730aa99','08d9c356-57d1-44b3-88e2-10d0e08eba7a'),('1395fb91-9863-48d2-b729-032c38084cb5','df63e966-7867-454a-bd8b-46991a26b37a','08d9c356-5741-4727-8d71-02f5beead493'),('1bf7dbfe-fbf6-47e5-9f20-91b7fc4e69ad','df63e966-7867-454a-bd8b-46991a26b37a','08d9c356-5732-4998-8ee7-f788e06ef0a8'),('1c3fad73-87e0-48b9-afdd-71113f38f6c0','c0febbe8-e6da-453a-a1fc-0e426730aa99','08d9c356-578a-4142-8367-7359cc1eb2ee'),('1fbc8b5b-2ca3-4239-9f4b-1ab85fa5ed0b','92274bdf-fc18-4c77-891a-3083752f49a1','08d9c356-5786-48c0-85f0-a21b26980d94'),('22e42cd2-b005-4994-8d2d-10ad3b77f64f','79d2df6a-9cee-4495-a87e-8d925bfc4676','08d9c356-57c1-415b-8bc1-845ceb498b61'),('28ae2f7f-013e-4473-8c3a-6828bfe96c60','c0febbe8-e6da-453a-a1fc-0e426730aa99','08d9c356-57cb-49f6-839c-6011fd8b6f53'),('2c1bba0b-c408-4be7-9ab6-8ea851bcdd06','aea33f65-e892-4770-9172-958a7daa8bb4','08d9c356-572d-4a40-883b-beb04aea4149'),('2c5859b6-7f41-4cbf-8762-2272f6f8870e','c0febbe8-e6da-453a-a1fc-0e426730aa99','08d9c356-5796-48cb-80f0-f66da15971ae'),('2fa6e5ff-c15f-47b5-b349-3b671be960c4','05c20eed-e70b-4acc-88d9-8deb99c8e974','08d9c356-5734-476b-8498-48ce3f18a146'),('33e6ed78-102d-4876-b872-e958cd0038b1','05c20eed-e70b-4acc-88d9-8deb99c8e974','08d9c356-57d8-4d79-8b33-e3837c3121d5'),('350d86d8-fbc4-45e8-a1f1-bc6a72d4348a','c0febbe8-e6da-453a-a1fc-0e426730aa99','08d9c356-57cf-447d-8b80-fb0ce48785cc'),('38820f0a-7f99-48ce-a0ba-781449a7b566','d9389a02-1726-46b3-837c-017e2bcf9704','08d9c356-572f-4522-8153-b123b1a51060'),('3d6087b8-d7a9-49fb-a16c-3fb8732e9573','121e3540-1d7f-48e3-8585-6ecd493940e2','08d9c356-5721-43fb-85be-dc0a9940388c'),('44813ac2-1946-449a-8f82-d627690072d9','92274bdf-fc18-4c77-891a-3083752f49a1','08d9c356-5743-4410-8407-c1122edaee10'),('45d092d8-2062-4644-974a-08ab2f9dd549','0d0a464a-d47d-42a9-b126-30a22670ac60','08d9c356-5725-4dc7-83e8-0c14d8e0ba45'),('4697e89a-f800-4906-bb53-0e11b773462d','282fdcb8-c753-4bac-aac4-29eab3aa26e2','08d9c356-575f-4804-8c54-3ca1d079119e'),('483181ca-ac2c-4ed0-8d28-029f55417cb0','282fdcb8-c753-4bac-aac4-29eab3aa26e2','08d9c356-573b-4cab-89e2-8cecb0a71877'),('4aa42436-99cc-4b85-9fc1-c0ef3cb28c11','d9389a02-1726-46b3-837c-017e2bcf9704','08d9c356-5793-41a1-8568-d6142e023037'),('4b2f60b9-ab54-4c2a-ad6c-c3aad46cf256','92274bdf-fc18-4c77-891a-3083752f49a1','08d9c356-5722-4ed1-8fab-5b700fd5f788'),('4fc5c78d-376d-483b-84fe-552e33aaea5c','f1c382d8-682e-44b0-8f82-8d98ffcc3a0d','08d9c356-576a-4a69-8a3b-4cf4d8fe29e5'),('505ca06a-0dfe-4834-8a62-bb1a9f65cdb0','c0febbe8-e6da-453a-a1fc-0e426730aa99','08d9c356-571f-4b81-8fa9-863d303648a3'),('50da6fda-61b9-4c63-9472-a3563dd707c9','92274bdf-fc18-4c77-891a-3083752f49a1','08d9c356-57c7-4164-867b-07eeb5463c0c'),('52680e09-fc3b-49c7-b14c-b79ac12c8b26','1307f5a7-1547-4936-aa82-6e7fcc28544d','08d9c356-577c-4231-8a1c-638925efa702'),('52d32fec-ad2d-4517-b1f6-8a0f3f16bc9b','d9389a02-1726-46b3-837c-017e2bcf9704','08d9c356-5784-4b82-8806-03f6a7855f71'),('538c42a4-2f28-4bec-90db-394d343ff0a6','aea33f65-e892-4770-9172-958a7daa8bb4','08d9c356-574a-4866-8110-09065d72e0c3'),('57622918-978d-453e-88b3-4086e00c3f3c','0d0a464a-d47d-42a9-b126-30a22670ac60','08d9c356-57b9-4ed6-87b2-f38bab85fa7c'),('5ad1fdff-78b7-4ebf-affa-9760598f9e77','1307f5a7-1547-4936-aa82-6e7fcc28544d','08d9c356-575d-4882-8610-4213001c0087'),('5ea0c4cb-5d81-4c5f-ade7-f8bc159ee12e','92274bdf-fc18-4c77-891a-3083752f49a1','08d9c356-5745-40ae-86ca-12de6c7d0187'),('65557b88-bd4c-4151-a78b-01f984e18010','0d0a464a-d47d-42a9-b126-30a22670ac60','08d9c356-576e-49df-8c33-141a4e5e8df6'),('6652e343-5215-4522-ac18-16ede1d9df6b','f1c382d8-682e-44b0-8f82-8d98ffcc3a0d','08d9c356-57c5-422d-8c75-a18040749c1b'),('671d35d9-a386-48f5-b66e-85af0e662637','121e3540-1d7f-48e3-8585-6ecd493940e2','08d9c356-5782-4bcc-81ba-6aa8fea8f6a0'),('68cc6ac7-7da9-4c1b-931b-aa5120609c55','1307f5a7-1547-4936-aa82-6e7fcc28544d','08d9c356-5727-4483-8848-30da9dad7acc'),('6cd9d5ec-5653-4ad7-88c2-c973a177e8a7','1307f5a7-1547-4936-aa82-6e7fcc28544d','08d9c356-57b0-4876-84f0-1c177a5efb94'),('6d18b375-c39d-4ab6-91a0-f855deb4a554','79d2df6a-9cee-4495-a87e-8d925bfc4676','08d9c356-5772-4d31-8916-179e3f9967d7'),('738dc2f0-8e85-494b-bd02-a7be35a3676d','f1c382d8-682e-44b0-8f82-8d98ffcc3a0d','08d9c356-57c3-4009-83e8-5b5f5ad96624'),('73ec444b-8607-4605-a155-5510a0b137d6','c0febbe8-e6da-453a-a1fc-0e426730aa99','08d9c356-574e-4257-81a4-ed596b0c942f'),('756cc54a-d8b9-4544-8904-b6e6f44654f7','1307f5a7-1547-4936-aa82-6e7fcc28544d','08d9c356-5791-45c3-84c0-c5cb70e7e76e'),('7786afc7-f891-4501-b9a4-dc0adf8fc8db','df63e966-7867-454a-bd8b-46991a26b37a','08d9c356-5724-46d4-8091-763ce2d7dbdc'),('78244ac2-3162-49c5-89de-2875d2009c0e','df63e966-7867-454a-bd8b-46991a26b37a','08d9c356-5748-4d30-802a-73b9f54e4aea'),('7bdd6d24-ad76-4ba4-8564-d2d6fa30af77','1307f5a7-1547-4936-aa82-6e7fcc28544d','08d9c356-57ae-48ea-81ef-bf4da4682ac9'),('7e795dd6-4be7-45d9-966d-5e49aa052a60','df63e966-7867-454a-bd8b-46991a26b37a','08d9c356-57a6-4b95-8c21-4e15daed22e9'),('7e91c8f1-284e-433e-9a2e-f37ef20c4e29','79d2df6a-9cee-4495-a87e-8d925bfc4676','08d9c356-5765-4acb-8ef1-724ce524acd1'),('803a8641-c60b-43cd-baa0-2d75755630f8','29e967b4-2769-4092-b39f-fbe483f82ce9','08d9c356-5718-4108-8b18-a59cb0a002b6'),('88cea001-d4b2-4675-9c30-a1dd71eff59a','92274bdf-fc18-4c77-891a-3083752f49a1','08d9c356-57cd-46ff-8094-060e95597e45'),('8ceda695-5dc1-400f-9f4f-7069123acf77','79d2df6a-9cee-4495-a87e-8d925bfc4676','08d9c356-579e-4800-8490-bd6c307d6f9b'),('8e0a4bbe-3fa3-48f7-8f1f-6a70a2dfd741','1307f5a7-1547-4936-aa82-6e7fcc28544d','08d9c356-57a0-47c6-800d-cd1da216e3e6'),('92fbd1f8-724e-426f-b133-665186cdedea','d9389a02-1726-46b3-837c-017e2bcf9704','08d9c356-573f-467c-8de3-75a55f3eb5dd'),('947bf3fd-f9d2-4d08-84a8-e99991efaf71','5d54dd37-0a6a-4c8c-bf82-c9e0bde44c26','08d9c356-571e-41df-876c-26234a7732a7'),('9866c3bc-b36e-474f-aac6-a0aad95c6cd5','df63e966-7867-454a-bd8b-46991a26b37a','08d9c356-5777-4b9e-82ce-eee52602b25f'),('9d2963ce-efdb-43bf-9c16-02fba6563dcc','df63e966-7867-454a-bd8b-46991a26b37a','08d9c356-579c-45a8-8215-8b676018f57a'),('a30e85f2-622d-463f-a3f3-8a249e2cd436','df63e966-7867-454a-bd8b-46991a26b37a','08d9c356-5759-4ea5-8b10-4209970ad0be'),('a634361e-7552-4cde-93a2-2b91c238e1ef','f1c382d8-682e-44b0-8f82-8d98ffcc3a0d','08d9c356-57bd-457c-81fe-2ea1ade237b3'),('a7610fca-4640-42c8-b88c-3113e66e614c','1307f5a7-1547-4936-aa82-6e7fcc28544d','08d9c356-57d5-4210-8f2f-539a59e242cd'),('ac85164f-2c06-490a-8af8-d95c24f57cdb','0d0a464a-d47d-42a9-b126-30a22670ac60','08d9c356-5798-4645-811d-560331bad4fb'),('b023939a-ee3c-4a2b-bda5-f1a5b7770279','79d2df6a-9cee-4495-a87e-8d925bfc4676','08d9c356-5780-4a9f-8edb-af185151e644'),('b1f1edfa-6b6e-4a94-8d89-f7202b02afc7','79d2df6a-9cee-4495-a87e-8d925bfc4676','08d9c356-57ac-4b65-8eac-32680a51bc41'),('b2335fad-8e6a-45f9-9bd8-f566b6fce95b','282fdcb8-c753-4bac-aac4-29eab3aa26e2','08d9c356-578f-48fc-8df1-ba902cc57d0e'),('b4d026eb-95b8-49ec-9f9d-0674befbe0f3','aea33f65-e892-4770-9172-958a7daa8bb4','08d9c356-57bf-448b-8df7-9026f3436849'),('b62dfbd0-b7e8-40ef-90d5-88d408a09959','282fdcb8-c753-4bac-aac4-29eab3aa26e2','08d9c356-57b2-4832-87b0-a97a7b5e57e1'),('b885359d-bb13-44b7-8e4f-4263ee5e2039','d9389a02-1726-46b3-837c-017e2bcf9704','08d9c356-578d-4ce7-809f-e44e6a205208'),('b8d07799-8cd6-4bf8-92ae-13dfcb8100a1','79d2df6a-9cee-4495-a87e-8d925bfc4676','08d9c356-5761-4580-8c28-92e5319ff134'),('b93b679c-f951-4013-98f9-9d8f41a08552','1307f5a7-1547-4936-aa82-6e7fcc28544d','08d9c356-57a2-4539-89a7-02abbffd46de'),('ba462de6-6508-40b9-9076-46d42ceda990','79d2df6a-9cee-4495-a87e-8d925bfc4676','08d9c356-57b4-45ae-86ed-639545a89af5'),('bc1ec50e-724c-475b-93b4-58ac0fab3cb8','c0febbe8-e6da-453a-a1fc-0e426730aa99','08d9c356-57c9-4915-8bba-f1263ac79706'),('be9fc7c2-1ae1-4c9b-80cc-eaf01afff382','79d2df6a-9cee-4495-a87e-8d925bfc4676','08d9c356-5775-46ef-8341-f3d1b3e4bcfc'),('bea512fe-4d12-454f-a44e-bc65c3118998','d9389a02-1726-46b3-837c-017e2bcf9704','08d9c356-5779-4ead-8070-039230895dd7'),('c07a6d72-2cd7-42c6-96cb-81cee756a61a','f1c382d8-682e-44b0-8f82-8d98ffcc3a0d','08d9c356-57a8-4c96-87d6-1144a697d729'),('c3f951ef-164e-40a6-a767-f6a91d24e52a','1307f5a7-1547-4936-aa82-6e7fcc28544d','08d9c356-57b7-4ffa-8f5a-2fdbc1d18beb'),('c72fa120-822b-401e-8394-b70fc3c7e7a2','121e3540-1d7f-48e3-8585-6ecd493940e2','08d9c356-578b-4fc3-8f62-bd1c757e8e83'),('cac0dfe9-2735-43bb-87cd-09e231415429','c0febbe8-e6da-453a-a1fc-0e426730aa99','08d9c356-5763-4474-8f4f-ddc3ce6595b9'),('ce5f3a9a-364d-412b-95d3-f03aa601fe0b','282fdcb8-c753-4bac-aac4-29eab3aa26e2','08d9c356-572b-4e20-8cd3-5476404b6c8d'),('ce9614c3-8cbd-4af6-994a-7bba60ff1da1','79d2df6a-9cee-4495-a87e-8d925bfc4676','08d9c356-572a-4585-899e-ef713e4a4e93'),('cffa6f75-07c8-4d15-99d8-25140112e77c','d9389a02-1726-46b3-837c-017e2bcf9704','08d9c356-5756-44bd-8b82-44b3ad80c35c'),('d127cd20-b7a4-4d26-bfb4-b1c5e26bad81','df63e966-7867-454a-bd8b-46991a26b37a','08d9c356-5753-4e58-8d90-28a8cf8ef47e'),('d3bba850-9565-4540-bc06-39ef0892abd0','05c20eed-e70b-4acc-88d9-8deb99c8e974','08d9c356-573d-4aab-8f77-6e929d391c35'),('d951d3d2-667f-4790-af72-4455c2b44d3f','1307f5a7-1547-4936-aa82-6e7fcc28544d','08d9c356-5750-4133-8bee-c4fc05748562'),('d9e3a2b7-7c44-4bb7-858d-e25f4c3fcc9d','d9389a02-1726-46b3-837c-017e2bcf9704','08d9c356-5788-45f8-85b5-3c845b214739'),('db6dac5e-da30-4daf-8880-24667910572d','92274bdf-fc18-4c77-891a-3083752f49a1','08d9c356-5768-4160-8f60-98ac80460646'),('dc87ecae-012f-4cd3-8d72-cdeab93ab090','05c20eed-e70b-4acc-88d9-8deb99c8e974','08d9c356-5728-4cec-8c2a-ef8d05026d79'),('de2e6345-73bd-45a0-9a09-67cb01224c5f','1307f5a7-1547-4936-aa82-6e7fcc28544d','08d9c356-5736-43d8-8c71-52a9a51c4975'),('de72cdf6-d077-486a-a7d7-2a8cf01bc33c','79d2df6a-9cee-4495-a87e-8d925bfc4676','08d9c356-5794-4d35-86f9-7884d9dffb6a'),('e099b1e0-4faa-421e-a0f3-9e4edfd79efc','faeb30e0-6093-4e18-bdc8-27eddf7c002f','08d9c356-571b-4242-8aaa-e9fd3c4c4fe9'),('e283c571-902b-4ecb-8749-cb9ef7857190','121e3540-1d7f-48e3-8585-6ecd493940e2','08d9c356-574c-447c-839b-6a48dd1778b4'),('e3762e46-5e7a-4f26-8b19-cd73b403c519','aea33f65-e892-4770-9172-958a7daa8bb4','08d9c356-57a4-4587-80ab-6b09bc395df1'),('e7fcb167-c45f-432c-af97-b9252f085c7f','92274bdf-fc18-4c77-891a-3083752f49a1','08d9c356-5770-48c8-8a61-26358f94648b'),('ed7428eb-dc6d-43f4-b849-a9ee600799d2','1307f5a7-1547-4936-aa82-6e7fcc28544d','08d9c356-5747-405a-82f5-56421b27a8ac'),('ef4fb769-3a03-4c23-8d01-51a87faf4784','d9389a02-1726-46b3-837c-017e2bcf9704','08d9c356-5758-4286-80af-c23a765135a6'),('ef6ccbb9-db60-40a3-a1a9-b2482b55b952','d9389a02-1726-46b3-837c-017e2bcf9704','08d9c356-57b6-4284-844f-9f61d5f635c7'),('efce653d-c8fe-491e-b8ea-797e0449725f','1307f5a7-1547-4936-aa82-6e7fcc28544d','08d9c356-5738-41a8-8275-035b5de6c310'),('f1732420-4e48-4734-b09e-0b4b0e19b016','1307f5a7-1547-4936-aa82-6e7fcc28544d','08d9c356-575b-4af2-824e-74800c938bc7'),('f458e668-ae76-4efb-81c6-88f1abeaa3bd','92274bdf-fc18-4c77-891a-3083752f49a1','08d9c356-57d3-44ac-857a-f9419c4d6db5'),('f4f36b0d-0e2e-409d-97d3-dabd60f59566','79d2df6a-9cee-4495-a87e-8d925bfc4676','08d9c356-577e-45c1-8bb0-1670d2b473d4'),('f81c313c-5992-43b9-a6da-280269664d9e','aea33f65-e892-4770-9172-958a7daa8bb4','08d9c356-57d6-4f4c-8e3e-bc2540e7effd'),('fb9cab68-39fa-4b75-8c57-2982229251a0','aea33f65-e892-4770-9172-958a7daa8bb4','08d9c356-579a-45e4-8199-e8b6f9932a5e'),('fc8d89c1-2d2f-4d00-8144-5fd3778c1b3d','f1c382d8-682e-44b0-8f82-8d98ffcc3a0d','08d9c356-5730-4f2e-830f-a3ef488f17ea');/*!40000 ALTER TABLE `organizationdepartmentwithorganizationdepartmentemployees` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `organizations`--DROP TABLE IF EXISTS `organizations`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `organizations` (  `Id` char(36) NOT NULL,  `TenantId` char(36) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `IX_Organizations_TenantId` (`TenantId`),  CONSTRAINT `FK_Organizations_Tenants_TenantId` FOREIGN KEY (`TenantId`) REFERENCES `tenants` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `organizations`--LOCK TABLES `organizations` WRITE;/*!40000 ALTER TABLE `organizations` DISABLE KEYS */;INSERT INTO `organizations` VALUES ('7711943c-6003-4381-8401-cf22e29b8d2c','2de1cd24-b4ad-41b3-937b-62088b818ebe');/*!40000 ALTER TABLE `organizations` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `projectmilestones`--DROP TABLE IF EXISTS `projectmilestones`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `projectmilestones` (  `Id` char(36) NOT NULL,  `Name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `StartDate` datetime(6) NOT NULL,  `EndDate` datetime(6) NOT NULL,  `ParentMileStoneId` char(36) DEFAULT NULL,  `ProjectId` char(36) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `IX_ProjectMileStones_ParentMileStoneId` (`ParentMileStoneId`),  KEY `IX_ProjectMileStones_ProjectId` (`ProjectId`),  CONSTRAINT `FK_ProjectMileStones_ProjectMileStones_ParentMileStoneId` FOREIGN KEY (`ParentMileStoneId`) REFERENCES `projectmilestones` (`Id`) ON DELETE RESTRICT,  CONSTRAINT `FK_ProjectMileStones_Projects_ProjectId` FOREIGN KEY (`ProjectId`) REFERENCES `projects` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `projectmilestones`--LOCK TABLES `projectmilestones` WRITE;/*!40000 ALTER TABLE `projectmilestones` DISABLE KEYS */;INSERT INTO `projectmilestones` VALUES ('74070242-7aa8-4d27-a7d5-885611d54015','项目新建','2021-12-20 09:16:25.988907','2033-02-03 00:00:00.000000',NULL,'08d9c356-57e6-4e49-8b91-1e70ee1ec6f3');/*!40000 ALTER TABLE `projectmilestones` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `projectobstacles`--DROP TABLE IF EXISTS `projectobstacles`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `projectobstacles` (  `Id` char(36) NOT NULL,  `Name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `Description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `StartDate` datetime(6) NOT NULL,  `EndDate` datetime(6) NOT NULL,  `Solution` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `ProjectTaskId` char(36) DEFAULT NULL,  `SubmitPersonId` char(36) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `IX_ProjectObstacles_ProjectTaskId` (`ProjectTaskId`),  KEY `IX_ProjectObstacles_SubmitPersonId` (`SubmitPersonId`),  CONSTRAINT `FK_ProjectObstacles_ProjectTasks_ProjectTaskId` FOREIGN KEY (`ProjectTaskId`) REFERENCES `projecttasks` (`Id`) ON DELETE RESTRICT,  CONSTRAINT `FK_ProjectObstacles_PurchaseGroupMembers_SubmitPersonId` FOREIGN KEY (`SubmitPersonId`) REFERENCES `purchasegroupmembers` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `projectobstacles`--LOCK TABLES `projectobstacles` WRITE;/*!40000 ALTER TABLE `projectobstacles` DISABLE KEYS */;INSERT INTO `projectobstacles` VALUES ('cbfa355f-b8a6-456d-8807-add142d8dd0b','查阅资料遇到了问题 ','网络不好','2021-12-20 09:16:26.069730','2033-04-04 00:00:00.000000','建议更换网络','98896bb4-1cc1-4cdd-ba91-7feeaad0a0e4','f7a331dc-ffc9-4dc0-bfed-0d471dd0f2da');/*!40000 ALTER TABLE `projectobstacles` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `projects`--DROP TABLE IF EXISTS `projects`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `projects` (  `Id` char(36) NOT NULL,  `Name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `ProjectStatusEnum` int NOT NULL,  `ProjectDemandId` char(36) DEFAULT NULL,  `ProjectStartTime` datetime(6) NOT NULL,  PRIMARY KEY (`Id`),  KEY `IX_Projects_ProjectDemandId` (`ProjectDemandId`),  CONSTRAINT `FK_Projects_HospitalDepartmentDemands_ProjectDemandId` FOREIGN KEY (`ProjectDemandId`) REFERENCES `hospitaldepartmentdemands` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `projects`--LOCK TABLES `projects` WRITE;/*!40000 ALTER TABLE `projects` DISABLE KEYS */;INSERT INTO `projects` VALUES ('08d9c356-57e6-4e49-8b91-1e70ee1ec6f3',NULL,0,'46efa054-866d-4490-b6c2-4ad381856ff7','2021-12-20 09:16:25.894721');/*!40000 ALTER TABLE `projects` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `projecttasks`--DROP TABLE IF EXISTS `projecttasks`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `projecttasks` (  `Id` char(36) NOT NULL,  `Name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `ProjectTaskTypeEnum` int NOT NULL,  `Description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `StartDate` datetime(6) NOT NULL,  `EndDate` datetime(6) NOT NULL,  `UserId` char(36) DEFAULT NULL,  `WorkId` char(36) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `IX_ProjectTasks_UserId` (`UserId`),  KEY `IX_ProjectTasks_WorkId` (`WorkId`),  CONSTRAINT `FK_ProjectTasks_ProjectWorks_WorkId` FOREIGN KEY (`WorkId`) REFERENCES `projectworks` (`Id`) ON DELETE RESTRICT,  CONSTRAINT `FK_ProjectTasks_PurchaseGroupMembers_UserId` FOREIGN KEY (`UserId`) REFERENCES `purchasegroupmembers` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `projecttasks`--LOCK TABLES `projecttasks` WRITE;/*!40000 ALTER TABLE `projecttasks` DISABLE KEYS */;INSERT INTO `projecttasks` VALUES ('98896bb4-1cc1-4cdd-ba91-7feeaad0a0e4','查阅资料任务',0,'查阅器材相关资料','2021-12-20 09:16:26.035953','2033-02-03 00:00:00.000000','f7a331dc-ffc9-4dc0-bfed-0d471dd0f2da','c7dcac9d-fbc4-400f-b262-117f2df7debf');/*!40000 ALTER TABLE `projecttasks` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `projectworks`--DROP TABLE IF EXISTS `projectworks`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `projectworks` (  `Id` char(36) NOT NULL,  `Name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `ProjectWorkTypeEnum` int NOT NULL,  `Description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `MileStoneId` char(36) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `IX_ProjectWorks_MileStoneId` (`MileStoneId`),  CONSTRAINT `FK_ProjectWorks_ProjectMileStones_MileStoneId` FOREIGN KEY (`MileStoneId`) REFERENCES `projectmilestones` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `projectworks`--LOCK TABLES `projectworks` WRITE;/*!40000 ALTER TABLE `projectworks` DISABLE KEYS */;INSERT INTO `projectworks` VALUES ('c7dcac9d-fbc4-400f-b262-117f2df7debf','制定初始计划工作',0,'项目刚开始我们要制定一些初始计划','74070242-7aa8-4d27-a7d5-885611d54015');/*!40000 ALTER TABLE `projectworks` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `purchasegroupmembers`--DROP TABLE IF EXISTS `purchasegroupmembers`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `purchasegroupmembers` (  `Id` char(36) NOT NULL,  `Position` tinyint(1) NOT NULL,  `GroupMemberId` char(36) DEFAULT NULL,  `PurchaseGroupId` char(36) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `IX_PurchaseGroupMembers_GroupMemberId` (`GroupMemberId`),  KEY `IX_PurchaseGroupMembers_PurchaseGroupId` (`PurchaseGroupId`),  CONSTRAINT `FK_PurchaseGroupMembers_OrganizationDepartmentEmployees_GroupMe~` FOREIGN KEY (`GroupMemberId`) REFERENCES `organizationdepartmentemployees` (`Id`) ON DELETE RESTRICT,  CONSTRAINT `FK_PurchaseGroupMembers_PurchaseGroups_PurchaseGroupId` FOREIGN KEY (`PurchaseGroupId`) REFERENCES `purchasegroups` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `purchasegroupmembers`--LOCK TABLES `purchasegroupmembers` WRITE;/*!40000 ALTER TABLE `purchasegroupmembers` DISABLE KEYS */;INSERT INTO `purchasegroupmembers` VALUES ('96c56fc6-14a0-48ad-af50-77da52791450',1,'08d9c356-57a6-4b95-8c21-4e15daed22e9','1c585124-7105-4a2e-b02b-843f3a0da1c8'),('f7a331dc-ffc9-4dc0-bfed-0d471dd0f2da',1,'08d9c356-57a8-4c96-87d6-1144a697d729','1c585124-7105-4a2e-b02b-843f3a0da1c8');/*!40000 ALTER TABLE `purchasegroupmembers` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `purchasegroups`--DROP TABLE IF EXISTS `purchasegroups`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `purchasegroups` (  `Id` char(36) NOT NULL,  `Name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `CreationTime` datetime(6) NOT NULL,  `NumberForPerson` int NOT NULL,  `GroupProjectId` char(36) DEFAULT NULL,  `GroupLeaderId` char(36) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `IX_PurchaseGroups_GroupLeaderId` (`GroupLeaderId`),  KEY `IX_PurchaseGroups_GroupProjectId` (`GroupProjectId`),  CONSTRAINT `FK_PurchaseGroups_OrganizationDepartmentEmployees_GroupLeaderId` FOREIGN KEY (`GroupLeaderId`) REFERENCES `organizationdepartmentemployees` (`Id`) ON DELETE RESTRICT,  CONSTRAINT `FK_PurchaseGroups_Projects_GroupProjectId` FOREIGN KEY (`GroupProjectId`) REFERENCES `projects` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `purchasegroups`--LOCK TABLES `purchasegroups` WRITE;/*!40000 ALTER TABLE `purchasegroups` DISABLE KEYS */;INSERT INTO `purchasegroups` VALUES ('1c585124-7105-4a2e-b02b-843f3a0da1c8','儿科化痰器采购小组','2021-12-20 09:16:25.931007',2,'08d9c356-57e6-4e49-8b91-1e70ee1ec6f3','08d9c356-57a6-4b95-8c21-4e15daed22e9');/*!40000 ALTER TABLE `purchasegroups` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `purchasingleadinggroupmebers`--DROP TABLE IF EXISTS `purchasingleadinggroupmebers`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `purchasingleadinggroupmebers` (  `Id` char(36) NOT NULL,  `Position` tinyint(1) NOT NULL,  `MemberId` char(36) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `IX_PurchasingLeadingGroupMebers_MemberId` (`MemberId`),  CONSTRAINT `FK_PurchasingLeadingGroupMebers_OrganizationDepartmentEmployees~` FOREIGN KEY (`MemberId`) REFERENCES `organizationdepartmentemployees` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `purchasingleadinggroupmebers`--LOCK TABLES `purchasingleadinggroupmebers` WRITE;/*!40000 ALTER TABLE `purchasingleadinggroupmebers` DISABLE KEYS */;INSERT INTO `purchasingleadinggroupmebers` VALUES ('ac4a417a-fe57-447b-a6c5-2af4516122ae',0,'08d9c356-5753-4e58-8d90-28a8cf8ef47e'),('ac80f12f-9837-4d7a-b616-b4fb35bcb19c',1,NULL);/*!40000 ALTER TABLE `purchasingleadinggroupmebers` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `tenants`--DROP TABLE IF EXISTS `tenants`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `tenants` (  `Id` char(36) NOT NULL,  `Name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `OrganizationCode` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `ExpirationTime` datetime(6) NOT NULL,  `CommonAddressId` char(36) DEFAULT NULL,  `TenantType` int NOT NULL,  `RegisterFund` decimal(65,30) NOT NULL,  `Corporate` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `CorporatePhone` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `CorporateEmail` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  PRIMARY KEY (`Id`),  KEY `IX_Tenants_CommonAddressId` (`CommonAddressId`),  CONSTRAINT `FK_Tenants_CommonAddresss_CommonAddressId` FOREIGN KEY (`CommonAddressId`) REFERENCES `commonaddresss` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `tenants`--LOCK TABLES `tenants` WRITE;/*!40000 ALTER TABLE `tenants` DISABLE KEYS */;INSERT INTO `tenants` VALUES ('2de1cd24-b4ad-41b3-937b-62088b818ebe','上和医院','91510104MA6CC78P90','2034-12-12 00:00:00.000000','8adff1d6-bd8d-4f9c-a0ce-ca34eea25896',1,5800.000000000000000000000000000000,'谢名洋','13448888520','82555783035@163.com');/*!40000 ALTER TABLE `tenants` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `worklogs`--DROP TABLE IF EXISTS `worklogs`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `worklogs` (  `Id` char(36) NOT NULL,  `CreatorId` char(36) DEFAULT NULL,  `CreateTime` datetime(6) NOT NULL,  `LogContent` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,  `ProjectId` char(36) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `IX_WorkLogs_CreatorId` (`CreatorId`),  KEY `IX_WorkLogs_ProjectId` (`ProjectId`),  CONSTRAINT `FK_WorkLogs_Projects_ProjectId` FOREIGN KEY (`ProjectId`) REFERENCES `projects` (`Id`) ON DELETE RESTRICT,  CONSTRAINT `FK_WorkLogs_PurchaseGroupMembers_CreatorId` FOREIGN KEY (`CreatorId`) REFERENCES `purchasegroupmembers` (`Id`) ON DELETE RESTRICT) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `worklogs`--LOCK TABLES `worklogs` WRITE;/*!40000 ALTER TABLE `worklogs` DISABLE KEYS */;INSERT INTO `worklogs` VALUES ('465f50df-01f0-495f-b70c-2a4228012560','f7a331dc-ffc9-4dc0-bfed-0d471dd0f2da','2021-12-20 09:16:26.130746','日志内容','08d9c356-57e6-4e49-8b91-1e70ee1ec6f3');/*!40000 ALTER TABLE `worklogs` ENABLE KEYS */;UNLOCK TABLES;/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;-- Dump completed on 2021-12-20  9:28:41hahhahhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhkkkkkkkkkkkkkk";
            str = str.Replace("CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci", "");
            Console.WriteLine(str);
        }
    }
}
